|
-
Jan 11th, 2025, 12:35 PM
#1
Thread Starter
Junior Member
Shutting down Excel in VB.net
Final problem (I think).
I have successfully loaded and updated and save an Excel spreadsheet in VB.net. But when I close down Excel as follows:
If txtSave.Text = "Y" Then
xlWb.Save()
xlWb.Close(False)
Else
xlWb.Close(False)
End If
xlWs = Nothing 'Sheet
xlWb = Nothing 'Workbook
xlApp.Quit()
xlApp = Nothing 'Application
According to the Task Manager, Excel is still running in the background. If I run the test enough times, I run out of memory due to multiple versions running in the background. I have to go into the Task Manager and "End Task" for each one.
I've looked everywhere to find out how people get it 'all' closed and can't find the correct answer although I have tried several suggestions.
Any help would be appreciated.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|