![]() |
Excel Workspace Save trouble
Have a got an issue with Excel Workspace Save option.
Earlier as part of coding for an Excel add-in in C#, I wanted to do some operation after a workbook was saved, using the newly saved workbook name. Realised soon that Excel did not expose any such event and had to use the usual workaround of cancelling the default save in BeforeSave handler and then doing an explicit save to get the old and new wokbook name. This had it's own set of issues but somehow everythin was chugging along, however realised today that there's an Excel Workspace save opion, which allows to save multiple workbooks simultaneoulsly. The problem with Workspace save is that actual save has been completed by the time control reaches the BeforeSave handler which is quite weird compared to the Workbook Save behavior, wherein control reaches the BeforeSave handler immediately on clicking the save menu. I was wondering if anybody here has any experience with handling Excel Workspace Save. Thanks |
All times are GMT +1. The time now is 01:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com