Setting Save As location

D

DBH

I would like to set the folder that I want to save a file to before hand.
What is the correct commands to do this?
I am creating an Excel application.
Thanks!
Dave H
 
N

new1

I would like to set the folder that I want to save a file to before hand.
What is the correct commands to do this?
I am creating an Excel application.
Thanks!
Dave H
Click to expand...

Hello,

If this applies for a specific workbook, here's my idea, i would
define a Sub Workbook_BeforeSave stating:

Application.DefaultFilePath="here_the_default_folder_path"

This will set the SaveDialog path to the specified path, but the
selection of another path by the user is still possible.


Regards

new1@[no/spam]realce.net
 
Top