Setting destination file default

  • Thread starter Thread starter Eric Stephens
  • Start date Start date
E

Eric Stephens

Using Access 2007, I would like to change the default destination when
exporting data to Excel (in other words, I don't want to have to click
"Browse" and find where I want to save the data every time). How do I do this?

Thanks,
Eric
 
Hi Eric,

I have set up a table that has only one record and numerous fields; one
field for each user default setting.

I set up a form so the user can set their inidividual options including
where to save exported Excel files. Instead of having labels for the text
boxes, I used command buttons and the user clicks the command button (label)
to make their default selection. I use
Application.FileDialog(msoFileDialogFolderPicker) to select the required
folder and then save it in the text box which is bound to the first (and
only) record in the table. (I lock the text box so it can only be populated
from the VBA code.)

You can then get the path from the table when required. Depending on how
much you want to code, you can make it the default and still use
Application.FileDialog(msoFileDialogFolderPicker) with the .InitialFileName
to start at the default location.
 
Back
Top