ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Workspace Save trouble (https://www.excelbanter.com/excel-programming/355043-excel-workspace-save-trouble.html)

[email protected]

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