View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Excel After Close?

It is application level. It doesn't die.

--
Regards,
Tom Ogilvy


"Die_Another_Day" wrote:

Bob, Can application.ontime be triggered to run a macro in another
workbook like personal.xls or does it die when the original workbook is
closed?

Die_Another_Day
Bob Phillips wrote:
Bit tricky, the workbook that the code will be in would then be closed.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Dev" wrote in message
...
I want to execute a macro after workbook closes? There is an event
"ThisWorkbook_WorkbookBeforeClose" but not Workbook After close..

Does anyone how to execute a macro ****after**** workbook close?

Any idea is really appreciated!!

Thanks!!