| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing Excel from a Macro
Hello,
A 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. How can I close Excel after code is executed? Thanks in advance! Jimmy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Closing Excel from a Macro
Application.quit
Rgds -----Original Message----- Hello, A 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. How can I close Excel after code is executed? Thanks in advance! Jimmy . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Closing Excel from a Macro
Thanks!! But Excel is still open. The spreadsheet is
closed but the Excel application is still running. Any way to close excel application? Thanks in advance! Jimmy -----Original Message----- Application.quit Rgds -----Original Message----- Hello, A 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. How can I close Excel after code is executed? Thanks in advance! Jimmy . . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Closing Excel from a Macro
If the Application.Quit line doesn't work, then maybe you have multiple copies
of excel running. On Wed, 11 Aug 2004 12:08:35 -0700, wrote: Thanks!! But Excel is still open. The spreadsheet is closed but the Excel application is still running. Any way to close excel application? Thanks in advance! Jimmy -----Original Message----- Application.quit Rgds -----Original Message----- Hello, A 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. How can I close Excel after code is executed? Thanks in advance! Jimmy . . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Closing Excel from a Macro
Yes... Only one excel open and still does not close excel.
Anything else?? Thanks! Jimmy -----Original Message----- Only one spreasheet running and still does not close excel application, -----Original Message----- If the Application.Quit line doesn't work, then maybe you have multiple copies of excel running. On Wed, 11 Aug 2004 12:08:35 -0700, wrote: Thanks!! But Excel is still open. The spreadsheet is closed but the Excel application is still running. Any way to close excel application? Thanks in advance! Jimmy -----Original Message----- Application.quit Rgds -----Original Message----- Hello, A 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. How can I close Excel after code is executed? Thanks in advance! Jimmy . . . . |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Closing Excel from a Macro
I think it was Excel.Quit statement
wrote in message ... Yes... Only one excel open and still does not close excel. Anything else?? Thanks! Jimmy -----Original Message----- Only one spreasheet running and still does not close excel application, -----Original Message----- If the Application.Quit line doesn't work, then maybe you have multiple copies of excel running. On Wed, 11 Aug 2004 12:08:35 -0700, wrote: Thanks!! But Excel is still open. The spreadsheet is closed but the Excel application is still running. Any way to close excel application? Thanks in advance! Jimmy -----Original Message----- Application.quit Rgds -----Original Message----- Hello, A 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. How can I close Excel after code is executed? Thanks in advance! Jimmy . . . . |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Closing Excel from a Macro
Hi Jimmy... try
Sub CloseNoSave() ThisWorkbook.Saved = True Application.Quit End Sub hope this helps... seeya ste |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking Column Status on closing excel - Macro Needed | Excel Discussion (Misc queries) | |||
| Closing Excel with Personal Macro Workbook | Excel Discussion (Misc queries) | |||
| CLosing Excel 2007 with personal macro workbook | Excel Discussion (Misc queries) | |||
| Closing Excel down with a macro? | Excel Programming | |||
| Problem in closing Excel App with translated excel macro | Excel Programming | |||
Linear Mode
