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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help with BeforeSave event 4
Object vs. New File in beforeSave event 7
Suggest a file name OnSave 2
BeforeSave event fired but not working when triggered by SaveAs. 3
BeforeSave, Cancel and ReadOnly 5
Use Workbook BeforeSave Event to Save Copy to Different Location 9
Creating ThisWorkbook Event Procedures 2
Save method and BeforeSave event 1

Back
Top