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
 

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

Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Default local file location - folder redirection slowness 0
Set as Default Template not working 0
Save last item copied 0
How can I save directly into the same folder every time in Office 365 / Windows 10? 0
Outlook 365 Signatures 0
Template location changes from user to user 0
Microsoft 365 Home edition - one drive duplicates 0

Top