+ Reply to Thread
Results 1 to 5 of 5

Select a file or folder

  1. #1
    Registered User
    Join Date
    03-10-2013
    Location
    N/A
    MS-Off Ver
    Excel 2010
    Posts
    62

    Select a file or folder

    Hi All:

    I have the following code to allow the user to select a file of his choice. I want ONLY to display *.xls*, BUT it also displays subfolders and shortcuts. How can I eliminate those.

    Also, can you help me with code to choose a FOLDER, not a file.

    Thanks,

    Yossi

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Post Re: Select a file or folder


    Hi,

    for the folder, you can use same property, just read FileDialog help to change its argument …

  3. #3
    Registered User
    Join Date
    03-10-2013
    Location
    N/A
    MS-Off Ver
    Excel 2010
    Posts
    62

    Re: Select a file or folder

    Quote Originally Posted by Marc L View Post

    Hi,

    for the folder, you can use same property, just read FileDialog help to change its argument …
    Marc,

    Thanks. That was helpful.

    One thing, though I couldn't find in the documentation. How do I prevent the display of subfolders and shortcuts? The .filters property restricts which filenames you see, but I can't get the subfolders and shortcuts to disappear.

    Thanks,

    Yossi

  4. #4
    Registered User
    Join Date
    07-17-2014
    Location
    Turkey
    MS-Off Ver
    2003
    Posts
    85

    Re: Select a file or folder

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    03-10-2013
    Location
    N/A
    MS-Off Ver
    Excel 2010
    Posts
    62

    Re: Select a file or folder

    I'm talking in the case when I'm trying to select a File. i.e

    Please Login or Register  to view this content.

+ 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. Modify code to select a file instead of folder
    By Liz_Biz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-02-2014, 11:19 PM
  2. [SOLVED] Modify existing code to select file instead of select folder
    By Gti182 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2014, 09:41 AM
  3. [SOLVED] User input to select file and save copy in hidden folder
    By RichTea88 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-13-2013, 10:24 AM
  4. [SOLVED] How to select any file in folder name (Left = "Final Test") then kill the file
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-30-2013, 12:40 AM
  5. Macro asking to select the folder and open file.
    By lalaarif1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-04-2013, 04:03 PM

Tags for this Thread

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