Darwin123456
New Member
- Joined
- Nov 5, 2022
- Messages
- 2
- Office Version
- 365
- 2010
Hi ,
I have some Vba that I am running in a workbook to open another workbook. However my colleagues have different drive letters so when they run the code they get an error, for example the file for me has fileparh Y:\Test\Test.xlsx however for my colleague it is Z:\Test\Test.xlsx.
Is it possible to detect what drive letter they are using and update the file path so they can use the code to open the other workbook?
Thanks in advance for any advice provided.
I have some Vba that I am running in a workbook to open another workbook. However my colleagues have different drive letters so when they run the code they get an error, for example the file for me has fileparh Y:\Test\Test.xlsx however for my colleague it is Z:\Test\Test.xlsx.
Is it possible to detect what drive letter they are using and update the file path so they can use the code to open the other workbook?
Thanks in advance for any advice provided.