| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a function for closing Excel using VB?
I have created a macro that saves the current worksheet to a specified
location with a specified name and then closes the worksheet. I would like to be able to close the Excel application itself from the macro. Can anyone tell me how? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a function for closing Excel using VB?
Application.Quit
-- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "Norm" wrote: |I have created a macro that saves the current worksheet to a specified | location with a specified name and then closes the worksheet. I would like | to be able to close the Excel application itself from the macro. | | Can anyone tell me how? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a function for closing Excel using VB?
Thanks Dave.
Funny thing is that Application.Quit does not work if it is preceeded by ActiveWorkbook.Close "Dave Patrick" wrote: Application.Quit -- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "Norm" wrote: |I have created a macro that saves the current worksheet to a specified | location with a specified name and then closes the worksheet. I would like | to be able to close the Excel application itself from the macro. | | Can anyone tell me how? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a function for closing Excel using VB?
Once the workbook is closed the code that is/was running terminates. You
shouldn't need that line. -- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "Norm" wrote: | Thanks Dave. | | Funny thing is that Application.Quit does not work if it is preceeded by | ActiveWorkbook.Close |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Closing workbooks w/o closing Excel | Excel Discussion (Misc queries) | |||
| Using "Find" function in Excel 2000, edit data without closing Fin | Excel Discussion (Misc queries) | |||
| close workbook without closing excel and stop recursive function | Excel Discussion (Misc queries) | |||
| Closing VB triggers closing Excel | Excel Programming | |||
| closing excel after closing a workbook | Excel Programming | |||
Linear Mode
