![]() |
how to recognize SaveChanges Parameter
hi there,
i have an AddIn that uses the Workbook BeforeClose event. now the wokbooks can be close using the "Workbook.Close SaveChanges=FALSE" method. depending on the value of the SaveChanges parameter of the Close method i need to do certain actions. is there any way to get the value of the SaveChanges Parameter (or even to know whether Close has been called with or without parameters?) thanks, guido |
how to recognize SaveChanges Parameter
Since you are writing the code that would set the parameters, you should be
able to determine what option you set and pass that information or store it so it can be accessed where you need it. I doubt there is a reliable way to determine it dynamically in the Workbook_BeforeClose event. -- Regards, Tom Ogilvy "Guido Buecker" wrote in message ... hi there, i have an AddIn that uses the Workbook BeforeClose event. now the wokbooks can be close using the "Workbook.Close SaveChanges=FALSE" method. depending on the value of the SaveChanges parameter of the Close method i need to do certain actions. is there any way to get the value of the SaveChanges Parameter (or even to know whether Close has been called with or without parameters?) thanks, guido |
All times are GMT +1. The time now is 02:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com