MS Access - Path Picker

Posted on 2011-04-29
Last Modified: 2012-05-11
I am familiar withe the use of "File Picker" --- Application.FileDialog(msoFileDialogFilePicker) --- and would like to employ a similar technique to pick a path in  a dialog box similar to explorer

Anybody have a simple solution?
Question by:rogerdjr
    LVL 43

    Accepted Solution

    LVL 44

    Assisted Solution

    You can use the same method, but tell it to select a folder.

      Dim fd As FileDialog
      Set fd = Application.FileDialog(msoFileDialogFolderPicker)
      Debug.Print fd.SelectedItems(1)

    Open in new window


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Most of my previous articles (, Rob the ComputorTutor)  on Office looked at the 2003 version, which was virtually identical to the 2002 and 2000 version, and very similar to their 97 and 95 versions.  However, recently, Microsoft int…
    Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
    This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now