ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to open a workbook from a template without hardcoding the path (https://www.excelbanter.com/excel-programming/283190-how-open-workbook-template-without-hardcoding-path.html)

Michael Turner

How to open a workbook from a template without hardcoding the path
 
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





All times are GMT +1. The time now is 12:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com