Local or Network drive

[gnissen]

Hi all, I have a bunch of files users can open on a network drive. But we have a fair amount of trouble accessing thus drive /G:\PVC\XXXX, so I run the same thing from my local drive C;\ PVC\XXXX.
how can you using vba do the following. If I open the main file C:\TEMPLATES.XLSM which holds all the macros going to different files when you press the macro button.
If I open the main file in C all other files will point to C.
If I open it in G, all other files will point to G.
Regards
Greg

 

[Micron]

On workbook opening, get the drive letter - left(activeworkbook.Path,1) and assign to a global variable. All your code would have to reference the global variable value in any hard drive path references. Or don't use C or G in your code; use relative paths. That means instead of using hard coded paths use something like ActiveWorkbook.Path, or ActiveWorkbook.FullName. Either way, it probably means you'd have to edit all of your code.