Hi,
I have a macro that I wrote that works fine if I'm running it on a drive that starts with a letter (ex. c:\ ... ). Basically, part of the code needs the current location of the Excel file that the macro is in for it to run properly. I have it working fine on a lettered drive with the snippet of code below.
[VBA]
MyCompletePath = ActiveWorkbook.FullName
MyPath = ActiveWorkbook.Path
SaveDriveDir = MyPath
ChDrive MyPath
ChDir MyPath[/VBA]
The problem is that once I send this macro out to others, some will run it on a network UNC path also (example
\\networkpath\ ... ). Is there an easy way to modify my code to have it work no matter where a person runs it??
Appreciate your help!!!