+ Reply to Thread
Results 1 to 3 of 3

concatenating the defualt path of browsefolder() to the user input path or folder name

  1. #1
    Registered User
    Join Date
    12-11-2018
    Location
    India
    MS-Off Ver
    2016
    Posts
    3

    concatenating the defualt path of browsefolder() to the user input path or folder name

    Hi All,

    I would like to concatenating the defualt path of browsefolder() to the user input path or folder name.

    I mean I would like to set the default path in browsefolder() and to this default path I would like to concat the folder names which user enters in the inputbox. Is it possible?

    strfolder = InputBox("Please enter the class", "Path")

    Set ShellApp = CreateObject("Shell.Application"). _
    BrowseForFolder(WINDOW_HANDLE, "Select folder:", NO_OPTIONS, "D:\Test\Class\")

    Like in above if user enters class as 'ABC' then browsefolder should directly goto path D:\Test\Class\ABC\.

    Regards,
    MaddyB

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,613

    Re: concatenating the defualt path of browsefolder() to the user input path or folder name

    Try something like this...
    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    12-11-2018
    Location
    India
    MS-Off Ver
    2016
    Posts
    3

    Re: concatenating the defualt path of browsefolder() to the user input path or folder name

    This works Thanks AplhaFrog.

+ 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. [SOLVED] Using BrowseFolder Control To Set Path For Saving
    By Logit in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2018, 12:04 PM
  2. [SOLVED] Help with Macro to find full path of Folder, using input of first 4 chars of folder name
    By Anxiety in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-28-2015, 09:02 AM
  3. How to validate an input dat folder/directory path whether the path has any spaces
    By mahendra.asapu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-21-2015, 02:39 AM
  4. 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
  5. Code to list the folder path and sub folder path of a specific file
    By kalai1587 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2013, 03:51 AM
  6. [SOLVED] Save As Dialog Box - Default Path and File Name, User Selects Sub Folder from Default Path
    By christenprochaska in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-12-2012, 05:17 PM
  7. Specified folder path to select file path
    By JayEmTee91 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-29-2012, 10:38 AM

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