+ Reply to Thread
Results 1 to 2 of 2

FileDialog(msoFileDialogFilePicker) exclude files in a list

  1. #1
    Registered User
    Join Date
    12-08-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    37

    FileDialog(msoFileDialogFilePicker) exclude files in a list

    Hi

    I was wondering if anyone knows how to exclude the files available for selection using the FileDialog(msoFileDialogFilePicker) the files that I want to filter out will be in column C of sheet1
    eg in column C there maybe Test.xlsm, Test1.xlsm, Test3.xlsm in rows 3 to 5 so these files should be excluded from the file picker so that Test4.xlsm, Test5.xlsm, etc are displayed.
    I have had a search around and can only find ways to exclude a file type not name.

  2. #2
    Registered User
    Join Date
    12-08-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: FileDialog(msoFileDialogFilePicker) exclude files in a list

    Anyone have any ideas?

+ 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. VBA to show excel files inside a folder Application.FileDialog(msoFileDialogFolderPicker)
    By Paul Cherian in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-03-2014, 08:17 AM
  2. msoFileDialogFilePicker read multiple files into seperate tables
    By gammaman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-02-2013, 10:57 AM
  3. msoFileDialogFilePicker: How to show csv and no other file types
    By ninmjj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-09-2013, 09:40 AM
  4. Exclude Files from GetOpenFileName based on File Name
    By jaslake in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-18-2011, 02:14 PM
  5. 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

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