How to open connected workbook with template

H

hstijnen

Hi,
I've developed a workbook1 with a connected workbook2 (for auxiliary
computations). The connected workbook2 is opened with VBA code in the
Workbook_Open() macro:

Workbooks.Open(ThisWorkbook.Path & "\workbook2.xls", 0, True)

Now I've changed workbook1 into a template. When I open a new workbook based
on that template teh Workbook_Open() macro is executed, but now
ThisWorkbook.Path is empty! And workbook2 cannot be found.

How can I open workbook2 in this situation?

Thanks for help

Henk
 

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

Similar Threads

Need to Keeping Same Display Value on 2 Workbooks 1
How to access a function from a different workbook 1
Workbook1 opens Workbook2 and runs Workbook2's macro 2
Export user inputs to a template and save it as a different file 1
Copy Sheet to New File Without Code 5
Automatically closing slave workbook when main workbook is closed... 0
minimize workbook 4
How to start template with connected workbook 2

Top