Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing Excel from VBA
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing Excel from VBA
Hi
normally application.quit should work. what is the code you have tried (have you eventually tried to close the workbook prior to this statement?) -- Regards Frank Kabel Frankfurt, Germany "Jimmy" schrieb im Newsbeitrag ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing Excel from VBA
I thought I advised to remove the Thisworkbook.close from the code.
I can't say if the form is interfering. Does the workbook close? If so, then I would say the form isn't the reason - the reason is because you close the workbook and code execution stops before reaching the quit command. -- Regards, Tom Ogilvy wrote in message ... 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 . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing Excel from VBA
Was using this code before I modified it to
thisworkbook.Close. frmTestimonials.Hide Application.ActiveWorkbook.Close False), "Testimonials.xls" Application.ActiveWindow.Close (False), "Testimonials.xls" Application.Quit Any other suggestions?? Thanks! Jimmy -----Original Message----- I thought I advised to remove the Thisworkbook.close from the code. I can't say if the form is interfering. Does the workbook close? If so, then I would say the form isn't the reason - the reason is because you close the workbook and code execution stops before reaching the quit command. -- Regards, Tom Ogilvy wrote in message ... 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 . . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing Excel from VBA
Thanks!
That worked.. removed the thisworkbook.Close before the App.Quit Thanks Tom! -----Original Message----- Was using this code before I modified it to thisworkbook.Close. frmTestimonials.Hide Application.ActiveWorkbook.Close False), "Testimonials.xls" Application.ActiveWindow.Close (False), "Testimonials.xls" Application.Quit Any other suggestions?? Thanks! Jimmy -----Original Message----- I thought I advised to remove the Thisworkbook.close from the code. I can't say if the form is interfering. Does the workbook close? If so, then I would say the form isn't the reason - the reason is because you close the workbook and code execution stops before reaching the quit command. -- Regards, Tom Ogilvy wrote in message ... 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 . . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing workbooks w/o closing Excel | Excel Discussion (Misc queries) | |||
Closing excel | Excel Worksheet Functions | |||
Closing Excel with Red X | Excel Discussion (Misc queries) | |||
Closing VB triggers closing Excel | Excel Programming | |||
closing excel after closing a workbook | Excel Programming |