BeforeSave: how to distinguish "Save" from "SaveAs" in Excel

[jmi44]

While in Workbook_BeforeSave, is there a way to tell whether the user saves the workbook (via menu File->Save or via the Save button) or whether she uses the menu File->Save As?

I need to execute some actions before the workbook is saved, and these actions depend on the save mode used.

 

[CautionMP]

The [tt]WorkbookBeforeSave()[/tt] event has a [tt]SaveAsUi[/tt] flag that will tell you if the user is doing a Save or SaveAs (Excel '03).

Hope this helps,
CMP

I am sorry I have not succeeded in answering all of your questions.
In fact, I apologize for not completely answering any of them.
The answers I have however do serve to raise a whole new set of questions I had not previously thought of. In some ways, I am as confused as you are but I believe my confusions are (as always) on a higher plane and

 

[jmi44]

Yes, this helps!
Thanks!