Closing Excel from VBA
Tried and it did not work.... Now I close the form,
maximize the workbook, then used
thisworkbook.Close
Application.Quit
Still not closing.. Could it be due to the Form??
Thanks in advance!
Jimmy
-----Original Message-----
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
.
|