Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Completely unloading excel from vb6. Is there an answer?
Hello,
I know this question has been asked a number of times and i have looked through google for an answer. However i still have not found an answer to how to completely unload Excel from vb6 without ctl+alt+delete. i use the standard code to open an excel doc using late binding Dim xlapp As Object Set xlapp = CreateObject("Excel.Application") xlapp.Visible = True Dim iNew As Integer Dim iOld As Integer Dim wb As Workbook Dim ws As Worksheet And to close i use this: xlapp.ActiveWorkbook.Close False xlapp.Quit xlapp.UserControl = False Set ws = Nothing Set wb = Nothing Set xlapp = Nothing Excel still is in the task manager and if you attempt to run the code again before closing the vb project it will crash each time!! Please Help!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculator Answer Doesn't Match Excel Answer | Excel Discussion (Misc queries) | |||
Not Unloading a UserForm | Excel Programming | |||
Unloading User Forms? | Excel Programming | |||
Unloading A Form | Excel Programming | |||
Unloading an Add-In | Excel Programming |