+ Reply to Thread
Results 1 to 4 of 4

Need To open and Save a folder location selected by user

  1. #1
    Registered User
    Join Date
    04-14-2014
    Location
    Three Forks, MT
    MS-Off Ver
    Excel 2007
    Posts
    3

    Need To open and Save a folder location selected by user

    I have the below code set that I need help modifying. What I am trying to do:

    1) Have the hard coded folder path be chosen by a user and then saved so that it can be used later in the code (Sub Rename Files)
    2) Have that folder path be the selected location for Sub Rename Files so that the user does not have to reselect the folder that they chose originally (step 1)

    Please let me know if there are any questions.
    Please Login or Register  to view this content.
    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer
    Last edited by 6StringJazzer; 07-28-2016 at 10:53 AM.

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,481

    Re: Need To open and Save a folder location selected by user

    Hi there,

    See if the following code does what you need:

    Please Login or Register  to view this content.
    The path to the folder selected by the User is stored in the module-level variable msFilePath so that its value will be available to the RenameFiles routine.


    Hope this helps - please let me know how you get on.

    Regards,

    Greg M

  3. #3
    Registered User
    Join Date
    04-14-2014
    Location
    Three Forks, MT
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Need To open and Save a folder location selected by user

    Thanks Greg, this worked for me! Appreciate the help

  4. #4
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,481

    Re: Need To open and Save a folder location selected by user

    Hi again,

    Many thanks for your feedback.

    You're welcome - glad I was able to help.

    Regards,

    Greg M

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Open Folder (Prompt User for final folder name in location path)
    By synergeticink in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-21-2014, 03:33 PM
  2. [SOLVED] [Help]macro to open file browser, to select a location, and save the location to a cell
    By zhuleijia in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-06-2013, 09:56 AM
  3. [SOLVED] Macro to prompt user for folder location and save acitve workbook.
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-06-2013, 06:20 PM
  4. Replies: 1
    Last Post: 07-24-2012, 09:53 AM
  5. User input for folder location
    By jmckee in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-02-2010, 03:09 PM
  6. Open a folder location with VBA?
    By comptechbranden in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-10-2007, 10:59 AM
  7. [SOLVED] Open folder - Activeworkbook location
    By al007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-26-2006, 09:40 PM

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