Hi,
In one of my VBA projects, I'm in need of a code to search for a given filename with its extension in "My Computer" (all the Computer and drives) and when found passing its full path to a string variable, and when not found assigning empty string to that variable. I have googled my question a lot but most of the codes that I have found were using FileSearch method which is no longer valid in Excel 2010.
I'm using 64 bit Windows 7 Professional with SP1 and Microsoft Excel 2010 (14.0.7109.5000) SP2 MSO (14.0.7113.5005).
Any help is highly appreciated.
Regards,
Levent