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

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.

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

Hi
have a look at the GetSaveAsFile method in the VBA help (there's an
example included)

--
Regards
Frank Kabel
Frankfurt, Germany


quartz wrote:
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.