Hi all,

I am writing an excel add-in using the microsoft.office.interop.excel namespace.
Here is the problem , How do I get code to fire after a workbook has been saved. This is need to allow me to capture the new workbook name that the workbook was saved as. Seem like microsoft over looked the need for an after save event. they did create a BeforeSave event ( which I am using) they did create an AfterXMLExport event. I also lookedat using the Codename property but as per the msdn that property does nto return a vaule through the .Net interface.

I was hoping anyone might have a suggestion on how to work around this problem. As I need to be able to reference the workbook by its' name.

As a side note I am looking also for a way to handle when a user changes a worksheet name. same need as above.