Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to see full path name of open workbook? | Excel Discussion (Misc queries) | |||
How to find file-path of open workbook? | Excel Discussion (Misc queries) | |||
Macro to open Workbook in default path. | Excel Discussion (Misc queries) | |||
How to open workbook from template without hardcoding | Excel Programming | |||
how to open workbook without hardcoding path | Excel Programming |