Hey Guys,

I'm looking to set a filepath to refer to the current drive/drive of the excel workbook.
Reasoning is macro is accessed from VPN, drive names are all different and multiples people run macro
Is there a way to set the drivename in the path to the current drive (as used in the file running the macro)?
for example

person 1.
drive is z drive, (rest of file-path is same), the current folder is in their z drive
Workbooks.Open Filename:="Z:\Reports\data\report 1.csv"
person 2.
M drive 
Workbooks.Open Filename:="M:\Reports\data\report 1.csv"
etc

merging these into one code
Workbooks.Open Filename:="Current drive:\Reports\data\report 1.csv"


Is this possible??


Thanks