Search Mapped Drives for File Name

[smpatty08]

Is it possible to have vba search through all mapped drives for a file name and open that file? I am trying to make a previously written code bullet proof by giving the users the ability to have a file that the macro uses saved anywhere rather than force them to remember to save it to a specified file. Any ideas on where to start would be greatly appreciated. Thanks

 

[RedBeard]

This might be of use: https://answers.microsoft.com/en-us...s/661cebfd-e587-4405-8131-0775dd6d8497?auth=1