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!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Completely unloading excel from vb6. Is there an answer?
Try not closing the file.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Hcoms" wrote in message ... 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!!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Completely unloading excel from vb6. Is there an answer?
Thanks for the idea , however it still keeps Excel loaded! Any more ideas??
"Bob Phillips" wrote in message ... Try not closing the file. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Hcoms" wrote in message ... 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!!! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Completely unloading excel from vb6. Is there an answer?
I don't use vb, do you use any other excel object variables (ranges???) that
need to be reset to nothing? Hcoms wrote: 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!!! -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Completely unloading excel from vb6. Is there an answer?
What other code have you got in your routine?
for instance, Set oWS = oExcel.ActiveSheet Range("A1").Value = 25 Application.DisplayAlerts = False Workbooks("Book1").Close should be Set oWS = oExcel.ActiveSheet oWS.Range("A1").Value = 25 oExcel.DisplayAlerts = False oExcel.Workbooks("Book1").Close If you do not Explicitly refence the Excel object you will get Excel will remain referenced even though you close & quit. Hcoms wrote: 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!!! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Completely unloading excel from vb6. Is there an answer?
Hcoms,
You say you are using late binding. Then you can't have the references to "Workbook" & "Worksheet" as you need a reference the Excel library. For me the above code allows Excel to unload, so the problem is in some of the code that you have not shown here. Also .UserControl is read only. NickHK "Hcoms" wrote in message ... 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!!! |
Reply |
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 |