Esteemed Forum Participants and Lurkers:
===============================
EXCEL
How can I preset the starting directory for the VBA File Picker object? I did a search on this forum but I didn't get any hits.
I tried "ChDir", but that doesn't affect the file picker.I tried the ".LookIn" property, but that generated an error ... it doesn't apply to the File Picker.Code:'Create a FileDialog object as a File Picker dialog box. Set fd = Application.FileDialog(msoFileDialogFilePicker)
Thank you for your comments, suggestions, and assistance.
THE RESOLUTION IS:
'Set the initial path to the C:\ drive.
fd.InitialFileName = "C:\Test"
It will open the picker to the C:\Test folder.


Reply With Quote