How to open workbook from template without hardcoding

[Michael Turner]

Could anyone tell me how to open a workbook from another workbook, where
both files are in the same folder, without hardcoding the path. I have tried
code like this without success.
Workbooks.open (path & "\somefile.xls")

 

[Steve Garman]

Could anyone tell me how to open a workbook from another workbook, where
both files are in the same folder, without hardcoding the path. I have tried
code like this without success.
Workbooks.open (path & "\somefile.xls")

Have you tried
Workbooks.open ("somefile.xls")

 

[Ron de Bruin]

You can use this

ThisWorkbook.Path