difference application.quit & application.close

[Pierre via OfficeKB.com]

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

 

[Tom Ogilvy]

The biggest difference is that there is no Application.Close command. You
quit the application (Excel) and close workbooks.

That should make it easy.

 

[Pierre via OfficeKB.com]

hi Tom,

If i close a workbook throug a sub, does it still run the beforworkbookclose()
sub?
Thanks,
Pierre

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

 

[Tom Ogilvy]

the
Workbook_BeforeClose event for the workbook being closed should run.

--
Regards,
Tom Ogilvy

hi Tom,

If i close a workbook throug a sub, does it still run the beforworkbookclose()
sub?
Thanks,
Pierre

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

 

[Pierre via OfficeKB.com]

thanks Tom !
Pierre

the
Workbook_BeforeClose event for the workbook being closed should run.

hi Tom,

[quoted text clipped - 12 lines]