Get the Excel Filename after a save
Remy,
I thin you are going to have to take that approach in some form. If the
workbook has already been saved before, you can get the fullname at that
point, if it hasn't, you could throw up a GetSaveAsFilename dialog and get
the name and then save, then cancel.
--
HTH
Bob Phillips
"Remy" wrote in message
oups.com...
Hello,
I need a way to figure out under what filename someone saved his
spreadsheet.
I basically would need an event like AfterSave (as there is one called
BeforeSave). I know that I could emulate the save behaviour in
BeforeSave and just return cancel, but I would rather not do that,
specially with all the filetypes that some excel versions support and
others dont'.
I also know that with ActiveWorkbook.FullName I can get that name, but
I'm not sure at which point I should do that?
Is there an event that gets called after a save happend or how can I do
this?
Thanks
Remy
|