+ Reply to Thread
Results 1 to 4 of 4

Specified folder path to select file path

  1. #1
    Registered User
    Join Date
    10-10-2011
    Location
    Michigan
    MS-Off Ver
    2007
    Posts
    13

    Specified folder path to select file path

    The question I have is, I used the following code for the user to use a commandbutton to select a specific folder for a file.

    Please Login or Register  to view this content.
    I want to use this folder path to re-open windows explorer to that path to allow a user to select the file they want to use and put the file path into the cell below it.

    It may sound over complicated in my method, but for my purposes, I need it to function this way. I don't have any solid code besides that, and I wanted to see if this was possible.

    Thank you!

  2. #2
    Forum Contributor BeachRock's Avatar
    Join Date
    11-01-2011
    Location
    Oregon, United States
    MS-Off Ver
    Excel 2016
    Posts
    403

    Re: Specified folder path to select file path

    Try this:

    Please Login or Register  to view this content.
    Is that what you need?

    EDIT: Looking back at your first post, I think I misunderstood. You want the path selected to be a link to that folder.. I found this on another thread that you could maybe work into your other macro, or mine, which I assume they probably both do the same thing...

    http://www.excelforum.com/excel-prog...hyperlink.html
    Last edited by BeachRock; 10-26-2012 at 05:12 PM.
    -------------
    Tony

  3. #3
    Registered User
    Join Date
    10-10-2011
    Location
    Michigan
    MS-Off Ver
    2007
    Posts
    13

    Re: Specified folder path to select file path

    Thank you for the reply.

    I don't think I provided enough detail with what I want to do.

    I have a command button that uses the code I posted, and I have a button in the cell below that one, which I want to open to the folder that was selected with the previous command, so that the user will be able to select a file from that folder and it will copy the path of that file to cell "B6." If that makes sense.

  4. #4
    Forum Contributor BeachRock's Avatar
    Join Date
    11-01-2011
    Location
    Oregon, United States
    MS-Off Ver
    Excel 2016
    Posts
    403

    Re: Specified folder path to select file path

    Replace your current macro code to the following:

    Please Login or Register  to view this content.
    Change ("YourWorksheet") to the name of the sheet where the file path will be created. This is a combination of the first code I provided and the code I gave you the link for above. It works for me to select the file path and then make that path into a link to the folder you selected. I couldn't get it to work with your original code. This doesn't do exactly what you wanted but it does make it a quick process to open the folder where files are saved so you can open them whenever you want.
    Last edited by BeachRock; 10-29-2012 at 10:44 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1