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!!!

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!!!

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!!!

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

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!!!

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!!!