View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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