+ Reply to Thread
Results 1 to 2 of 2

Code not browsing the desired folder path to open file

  1. #1
    Forum Contributor prabhuduraraj09's Avatar
    Join Date
    05-19-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    330

    Exclamation Code not browsing the desired folder path to open file

    Hi Guys,

    I have enclosed below code , not entire code but partial.
    The actual functionality of this code is, upon click of a button the code will show Open window to specific folder for user to choose file.

    That is all. But the issue is, though path has been provided in the code the open window not showing desired folder but showing my document or just drive like R: drive.

    Can someone tell me what is wrong on this code.

    All that i need is code should open window and land up in desired folder, for user to choose file.

    HTML Code: 
    Please Help
    Thank you

    If I have helped you in someway, use the * icon below to give reputation feedback, it is appreciated.

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

    Re: Code not browsing the desired folder path to open file

    ChDrive doesn't work for network drives. Only for drive letters.

    Try this...

    Please Login or Register  to view this content.
    Last edited by AlphaFrog; 09-21-2016 at 03:18 AM.
    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.

+ 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. Replies: 2
    Last Post: 12-29-2015, 04:19 AM
  2. Macro to open a file and folder that has date in the path based on a cell value
    By mm671750 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-07-2015, 06:31 PM
  3. 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
  4. [SOLVED] Open file by macro from active folder path
    By xbr088 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2013, 10:11 PM
  5. Open .csv file without browsing it using command button
    By jericlapuz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-11-2012, 10:23 PM
  6. [SOLVED] Browsing to open a file in VBA
    By JungleJme in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-28-2012, 05:39 AM
  7. consolidating excel files into one file not using hard code of folder path
    By rrakkki in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-21-2011, 09:05 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