Make "BeforeSave" event supply a default path and file name?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In VBA, Excel XP & Win 2k

is there a way when using the "BeforeSave" event to make the "Save As" dialog box pop up with a suggested path and file name already supplied

Is so, could someone please post back example code on how to do this? Thanks in advance.
 
Hi
have a look at the GetSaveAsFile method in the VBA help (there's an
example included)
 
Back
Top