+ Reply to Thread
Results 1 to 3 of 3

msoFileDialogFilePicker: How to show csv and no other file types

  1. #1
    Registered User
    Join Date
    12-27-2012
    Location
    Miami
    MS-Off Ver
    Excel 2010
    Posts
    4

    msoFileDialogFilePicker: How to show csv and no other file types

    Hi,

    I have a great little macro that works perfectly with one small frustration.

    I would like my Application.FileDialog(msoFileDialogFilePicker) to only show subfolders and csv files.
    Normally, this works, but if the folder contains shortcuts to other files (even non-csv files), the icons for these shortcuts appear.


    Here is my code:
    Please Login or Register  to view this content.
    Thanks you in advance for your help.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: msoFileDialogFilePicker: How to show csv and no other file types

    Hello ninmjj,

    This should do what you want and will less code...
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    12-27-2012
    Location
    Miami
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: msoFileDialogFilePicker: How to show csv and no other file types

    Hi Leith,
    Thank you for your reply, but this does not resolve my issue.

    In the folder of my choice, I would like to only see subfolders and .csv files.
    Your method (and mind) shows shortcuts to other files and folders. I don't want shortcuts to appear.

    I only want to see a list of subfolders and below it a list of csv files that are in that directory.

    Thanks, though.

+ 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. Pivot to show two data types
    By brad_x81 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-16-2012, 07:20 AM
  2. Combine two file types
    By aschwalge in forum Excel General
    Replies: 0
    Last Post: 06-21-2012, 11:42 AM
  3. Using Excel built-in dialogs:-msoFileDialogFilePicker, are necessary tools
    By torspake in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-13-2011, 03:42 AM
  4. file types
    By SuitedAces in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-29-2008, 03:40 PM
  5. saving in other File types
    By Jason in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2006, 12:30 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