Results 1 to 1 of 1

Thread: EXCEL: How To: Preset Starting Directory for File Picker [Resolved]

Threaded View

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    May 2004
    Location
    Carlisle, PA
    Posts
    1,045

    Resolved EXCEL: How To: Preset Starting Directory for File Picker [Resolved]

    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.
    Code:
        'Create a FileDialog object as a File Picker dialog box.
        Set fd = Application.FileDialog(msoFileDialogFilePicker)
    I tried the ".LookIn" property, but that generated an error ... it doesn't apply to the File Picker.

    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.
    Last edited by Webtest; Jun 2nd, 2005 at 11:06 AM. Reason: RESOLVED
    Blessings in abundance,
    All the Best,
    & ENJOY!

    Art . . . . Carlisle, PA . . USA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width