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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 05:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com