View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Closing Excel from VBA

Do you close your workbook before you call quit?

.. . .
thisworkbook.Close
Application.Quit
End Sub

if so, the code stops executing when the workbook is closed, so it never
gets the quit. If you remove the close command, then application.quit will
be executed and this will take care of closing your workbook.

--
Regards,
Tom Ogilvy

"Jimmy" wrote in message
...
Hello,

Have a macro that emails out certaing information and
would like to closed or Exit Excel once code is executed.
Right now I have a Mssage box that let's the user know it
finished emailing the information but it advises the user
to please close excel.

Only one excel spreasheet opened and tried the
Application.Quit but that does not closes Excel.

Any ideas?

Thanks in advance!
Jimmy