| 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 | |||
![Pierre via OfficeKB.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
