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.
