Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot save workspace | Excel Discussion (Misc queries) | |||
Trouble with 'save as' or making changes | Excel Discussion (Misc queries) | |||
save as xlw (workspace format) | Excel Discussion (Misc queries) | |||
Workspace & Links referenced when workspace opened. | Excel Worksheet Functions | |||
Application.save gives a workspace file? | Excel Programming |