Question How to open two Excel templates as two worksheets in one workbook

[pjm0424]

Hi,

Does anyone have an example of how to open two templates as worksheets in one workbook? I can open the worksheets in seperate workbooks but would like both worksheets to display in one workbook.

Very new to VB.Net.

Thanks!

PJ

 

[ss7thirty]

3 workbooks, copy sheets from A and B to C via Workbook.Sheets.Add(SheetYouWantToAdd).

 

[JohnH]

book.Sheets.Add(Type:="d:\sheetA.xlt")
book.Sheets.Add(Type:="d:\sheetB.xlt")