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