G
Guest
Hi All,
How do i exactly trap the close event of a excel workbook. I need to now the
name of the workbook which is closed. I tried using Workbook_BeforeClose
event.But if the user presses cancel this event is of no use. Then i went
though the Pearson events http://www.cpearson.com/excel/events.htm tutorial
and combined Window_Deactivate and Beforeclose to get exactly the close
event.When there multiple worksheets open this method also fails. Could any
one tell exact way to catch this event.Any code available would be grateful
Thanks in advance
Thanks
Xcelion
How do i exactly trap the close event of a excel workbook. I need to now the
name of the workbook which is closed. I tried using Workbook_BeforeClose
event.But if the user presses cancel this event is of no use. Then i went
though the Pearson events http://www.cpearson.com/excel/events.htm tutorial
and combined Window_Deactivate and Beforeclose to get exactly the close
event.When there multiple worksheets open this method also fails. Could any
one tell exact way to catch this event.Any code available would be grateful
Thanks in advance
Thanks
Xcelion