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.
Bookmarks