i have this bit of code that saves a file, how to default it to a folder

**dmcgov** · 05-11-2016, 02:54 PM

here is my code that works:

Please Login or Register  to view this content.

now how can i pre-set the folder for this save?

can anyone help me with this?

**Norie** · 05-11-2016, 03:16 PM

That code doesn't save a file, it opens a dialog to allow the user to enter a filename and location for the file to be saved.

If you want the dialog to open in a specific folder specify it with the InitialFileName argument.

For example, this will open the dialog in the folder Test on the C:\ drive.

Please Login or Register  to view this content.

**dmcgov** · 05-16-2016, 09:29 AM

many thanks for that. sorry it took me awhile to give you a gold star.

**dmcgov** · 05-16-2016, 04:28 PM

so it took me a bit to realize that this routine is not saving the CSV file. Is there something wrong with this code?

Please Login or Register  to view this content.

**Norie** · 05-16-2016, 04:38 PM

Like I said that code does not save a file, it just gets the filename and destination fom the user.

You'll need further code to actually do the saving.

What exactly are you trying to save?

**dmcgov** · 05-17-2016, 08:20 AM

im trying to save the Import tab as a CSV file.

can you help?

**dmcgov** · 05-23-2016, 04:15 PM

Originally Posted by dmcgov

so it took me a bit to realize that this routine is not saving the CSV file. Is there something wrong with this code?

Please Login or Register  to view this content.

so just need to add this one line to make it work

Please Login or Register  to view this content.

i have this bit of code that saves a file, how to default it to a folder

LinkBack

Thread Tools

Rate This Thread

Display

i have this bit of code that saves a file, how to default it to a folder

Re: i have this bit of code that saves a file, how to default it to a folder

Re: i have this bit of code that saves a file, how to default it to a folder

Re: i have this bit of code that saves a file, how to default it to a folder

Re: i have this bit of code that saves a file, how to default it to a folder

Re: i have this bit of code that saves a file, how to default it to a folder

Re: i have this bit of code that saves a file, how to default it to a folder

Thread Information

Users Browsing this Thread

Similar Threads

VBA code excel list of folder name, the folder path of subfolder, the file name & revision

Save Button that looks up latest file in folder, adds one and saves

[SOLVED] Save As Dialog Box - Default Path and File Name, User Selects Sub Folder from Default Path

[SOLVED] Run a Macro every 7 days that saves the file in a different folder

Code to print all files in a folder (to default printer)

Selecting Default Folder in Open File Dialogue Box Problem

[SOLVED] Need code to save file to new folder, erase from old folder

Bookmarks

Bookmarks

Posting Permissions