Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
difference application.quit & application.close
Hi,
just a small vba question for you... What is the difference between application.quit and application.close and when do i use quit and when close? Thanks, Pierre -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200511/1 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
difference application.quit & application.close
The biggest difference is that there is no Application.Close command. You
quit the application (Excel) and close workbooks. That should make it easy. -- Regards, Tom Ogilvy "Pierre via OfficeKB.com" <u13950@uwe wrote in message news:570f479fefd39@uwe... Hi, just a small vba question for you... What is the difference between application.quit and application.close and when do i use quit and when close? Thanks, Pierre -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200511/1 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
difference application.quit & application.close
hi Tom,
If i close a workbook throug a sub, does it still run the beforworkbookclose() sub? Thanks, Pierre Tom Ogilvy wrote: The biggest difference is that there is no Application.Close command. You quit the application (Excel) and close workbooks. That should make it easy. Hi, [quoted text clipped - 6 lines] Thanks, Pierre -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200511/1 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
difference application.quit & application.close
the
Workbook_BeforeClose event for the workbook being closed should run. -- Regards, Tom Ogilvy "Pierre via OfficeKB.com" <u13950@uwe wrote in message news:5710c98ae66ec@uwe... hi Tom, If i close a workbook throug a sub, does it still run the beforworkbookclose() sub? Thanks, Pierre Tom Ogilvy wrote: The biggest difference is that there is no Application.Close command. You quit the application (Excel) and close workbooks. That should make it easy. Hi, [quoted text clipped - 6 lines] Thanks, Pierre -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200511/1 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
difference application.quit & application.close
thanks Tom !
Pierre Tom Ogilvy wrote: the Workbook_BeforeClose event for the workbook being closed should run. hi Tom, [quoted text clipped - 12 lines] Thanks, Pierre -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200511/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application.Quit | Excel Programming | |||
Application.Quit | Excel Programming | |||
macro to close excel application other than application.quit | Excel Programming | |||
unable to close macro using auto_close or application.quit | Excel Programming | |||
application.quit will not shut off application | Excel Programming |