How to open a workbook from a template without hardcoding the path

M

Michael Turner

Hi

Thanks for the answer to my previous question but I left out a vital point
sorry.

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

This code works fine when opening a workbook from another workbook, but
not from a template.

Thanks in advance

Mick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top