Lee,

You could use the BeforeSave event and handle the whole saving process in
your code. Then you'll know the name of the file by the end of the
procedure.

Rob


"Lee Drage" wrote in message
...
I need to get the new name of a workbook immediately after the workbook is
saved. Is there an event that is triggered AFTER a save is performed i.e. I
need an event like Workbook_AfterSave. I guess I can set a flag in the
Workbook_BeforeSave event and then whenever the workbook/worksheet/ etc is
clicked check this flag is if set record the workbook name. Any better
ideas?


Thanks

Lee