Margie Said:

File Locked for Editing, How to unlock using VB6 code?

We Answered:

Next time you get the file locked message, check your task manager and look to see how many copies of excel are running. If you have improperly closed Excel you will see extra copies running. You can manually close these (end task) without having to restart the computer. Since you improperly leave Excel running when you close your application the computer has no way of knowing wether or not the file is being used or not. So it err's on the safe side and denies you access because as far as the PC is concerned the file is in use. The solution is to properly open and close Excel so that you do not leave an orphan application running in the background when you quit your VB application.

To avoid this make sure that you first close your Excel program before you close the VB program.

Set obok = Nothing
Set osht = Nothing
excel.Application.Quit

In you code above, your setting the Excel variable to nothing before you close the application. You are also not using the Excel variable to open Excel but rather are calling it dirrectly.


Instead use a variable set to a new instance of Excel and use the variable to open the workbook instead of directly calling Excel.
Use the Excel variable that your created to first close the Excel application before you set it to nothing.


EDIT:

rivate Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'Add COM reference "Microsoft Excel 11.0 Object Library" to project
Dim XL As New Excel.Application

Dim wkb As Excel.Workbook
Dim sht As Excel.Worksheet

Dim row, col As Integer

row = 1
col = 1
Me.WindowState = FormWindowState.Maximized
'Open Excel and create a new workbook
XL.Application.Visible = True
wkb = XL.Workbooks.Add
sht = wkb.ActiveSheet

sht.Cells.Item(row, col) = "Test "
col = col + 1 'move to next column

For col = 2 To 10
For row = 1 To 30
For z As Integer = 1 To 10000000
'waste time to slow down
'so that you can watch loading of data
Next
'load dummy data into cells
sht.Cells.Item(row, col) = row * col
Next
Next

XL.WindowState = Excel.XlWindowState.xlMinimized
MessageBox.Show("Click OK to Close Sheet")
XL.WindowState = Excel.XlWindowState.xlMaximized

wkb.Close()
XL.Quit()

sht = Nothing
wkb = Nothing
XL = Nothing

GC.Collect() 'release used memory

End Sub

Hugh Said:

Help me with Pride and Prejudice?

We Answered:

I LOVE this novel! Jane Austen is so awesome!

Erm, right at this moment I can recall some few instances, where Elizabeth's opinions alterted.

One instance is when Elizabeth finds out that Mr Darcy paid William (I think that's what he was called) off (the one who ran off with Lydia, I think it was). Mr Darcy basically got rid of William by paying him off and saving the Bennetts from all the scandal that would have come about Lydia running off with the guy. Elizabeth was so grateful and realised he's not such a mean old baddy!

In the middle of the novel I think, Elizabeth witnesses the way in which Mr Darcy communicates and cares for his sister and she's very surprised and warmed. Those moments alter Elizabeth's opinion of him.

Also when Mr Darcy speaks to Mr Bingley and realters his stance on Mr Bingley's and Jane's engagement, Elizabeth is molified and grateful. Mr Darcy, if I recall correctly, spoke to Mr Bingley and that's why Mr Bingley comes back and asks for Jane's hand in marriage. And of course, Jane is Elizabeth's sister and best friend - so this act makes her overjoyed!

I haven't read the novel in a while so hope this helps!

Erika Said:

Excel Macro Help - Filter and then input?

We Answered:

Yahoo Answers clips some of your code.
Send me your sheet with your questions and I'll have a look Excelpert@cfl.rr.com

Sheila Said:

Transfering Data from Excel to Word Macro?

We Answered:

Are you using the Word.Application object? If not, you need to call that, which you can then use to perform operations on as if you were writing a Word macro. Eg. you can record a macro in Word that does what you want (open file, paste text, format, then save and close). Then copy the code it generates, and put it in your Excel macro, operating on the Word.Application object.

Victor Said:

What do I leave the sub?

We Answered:

Twenty pages of worksheets? Are you joking? That is just going to bore the students into bad behaviour. Why not assign a different review activity? Maybe assign each group a major vocab AND grammar concept from the semester, and have them design a game to test their classmates' knowledge of that area. Or again, give groups a grammar and vocab concept and have them work together to write a script for a short play (or scene) that reviews that concept. Let them work together to memorize the play and they can perform it when you return to show the work they did.

As for English, if you normally spend the entire block in silent reading then I guess you could continue to do that. But again, why not give the students something that actually ENGAGES them in the learning process? Have them find a news story that reflects one of the central issues in the play. When they come to class they can work in groups to discuss how their chosen story relates to the play. Then ask them to swap news stories with a partner and write a letter to the editor relating that story to the play to current events to their opinions.

The worst thing you can do when you've got a sub is to give the kids mindless work, which seems to be exactly what you've got planned. You're just asking for them to act out.