+ Reply to Thread
Results 1 to 4 of 4

Emulate Excel 97 getopenfilename "Advanced" find including "Search subfolders"

  1. #1
    Registered User
    Join Date
    02-07-2014
    Location
    Genntown
    MS-Off Ver
    Excel 2003, 2010
    Posts
    20

    Emulate Excel 97 getopenfilename "Advanced" find including "Search subfolders"

    VBA Excel 97 getopenfilename included an "Advanced" button that invokes a subdialog enabling specification of additional filters and search/find in subfolders. How do I duplicate this functionality in Excel VBA 2010? I have exhausted my ability to hack into it via Google searches. I haven't found a solution, short of starting from zero and building my own getopenfilename dialog... At present, I don't need the full functionality of the Excel 97 dialog, but need the "Search subfolders" option I Excel 2010. I've gotten around it until now by retaining Excel 97 on my machine, but company security rules no longer permit... Anybody have an idea about why this functionality went away??? Any hints will be much appreciated. Holler if you need some screen dumps illustrating the '97 functionality.
    Attached Files Attached Files
    Last edited by FORTRANguru; 03-05-2014 at 08:57 PM. Reason: add illustration

  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: Emulate Excel 97 getopenfilename "Advanced" find including "Search subfolders"

    Hello FORTRANguru,

    If you were to provide some specific examples of the functionality you need to emulate then we could offer some realistic solutions.
    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
    02-07-2014
    Location
    Genntown
    MS-Off Ver
    Excel 2003, 2010
    Posts
    20

    re: Emulate Excel 97 getopenfilename "Advanced" find including "Search subfolders"

    I solved my own problem. I didn't realize I could use the search function in the upper right corner of the open dialog in conjunction with getopenfilename. Duh...

  4. #4
    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: Emulate Excel 97 getopenfilename "Advanced" find including "Search subfolders"

    Hello FORTRANguru,

    Sometimes the obvious isn't. I have been there a few times. Thanks for posting back with the solution.

+ 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] Amending various excel files including those in subfolders MACRO
    By gonzalraf in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-20-2013, 02:15 PM
  2. Find *.xls files in a directory and run macro(including *.xls located in subfolders)
    By driftlogic in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-12-2012, 11:34 AM
  3. Macro to search folder including subfolders for file and open
    By kiraexiled in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-01-2012, 02:45 PM
  4. [SOLVED] Search subfolders in excel 2010
    By greasybob in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-08-2012, 07:03 PM
  5. Formulas to emulate advanced filter feature
    By scottyd in forum Excel General
    Replies: 3
    Last Post: 09-23-2010, 04:08 PM

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