View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hstijnen hstijnen is offline
external usenet poster
 
Posts: 13
Default How to start template with connected workbook

Hi,
I've developed a workbook wb1 with a connected workbook wb2. Wb2 is open
with VBA in the Workbook_Open():

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

Now I've changed wb1 into a template. When I now make a new workbook based
on the template the Workbook_Open() macro is executed. But now
ThisWorkbook.Path is empty! And the connected wb2 cannot be found.

What can I do to open wb2 in this situation?

Thanks for help,

Henk