application quit problem
Make sure that all objects are cleared, such as
Set ie = Nothing
Also make sure that all objects are properly qualified, and as a last
resort, remove any With ... End With blocks as these have been known to
cause a problem.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"John" wrote in message
...
I have a module that opens an itrnaet page and then is suppose to close
excel down without saving changes. The following code closes the workbook
but does not close the excel application, can anyone advise how I can get
excel to terminate ?
If uid < 0 Then
Set ie = CreateObject("Internetexplorer.Application")
ie.Visible = True
ie.navigate "inside.mysite.com\qbrowse\lizard\expenses.asp?uid =" &
uid
End If
Application.DisplayAlerts = False
Application.Quit
Thanks in anticipation
John
|