Macro to open Spreadsheet

[Randall Roberts]

I have a speadsheet with a macro in it to open another spreadsheet
this is going to be used by different users

the macro specifies a path to open =c:\rsr\desktop\filename.xls for
example

Since this will be used for different users is it possible to make the
path more generic so as long as the original spreadsheet and the one
to be opened are in the same folders it will work no matter what
computer on a network uses it

Thanks
Randall

 

[Harald Staff]

Hi Randall

Try

ThisWorkbook.Path & "\filename.xls"

HTH. Best wishes Harald

 

[Randall Roberts]

thanks worked great

Hi Randall

Try

ThisWorkbook.Path & "\filename.xls"

HTH. Best wishes Harald