Automatically detect and change drive letter

[JamesT1]

Good Afternoon Guys

On a userform with a button to open another workbook and close the current one, I use this code..... It works fine, however it will be used by different people and may need to sit on different drive for some.

The folder structure will remain the same but how do I change it to automatically detect and change the path for the different drives

Please Login or Register  to view this content.

Many thanks for your help

JT

[JosephP]

do you mean the actual path will be different or just a different drive mapping to the same location? if the latter use a UNC path

[ragulduy]

I'd guess you could usually get away with:

Please Login or Register  to view this content.

[JamesT1]

Hi Guys

yudlugar,, that works for me and does wjhat I need.. many thanks

JosephP,, the folder structure will be the same but the drive mapping would be different,, some on H, some on C etc

Thanks for the help guys

JT