I think you are mixing up the Workbooks.Add and Worksheets.Add methods.

Try opening the template file, and copying across that sheet, then close it.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"CodeKracker" wrote in message
...
Hi all,
I am trying to insert a worksheet from one excel workbook to
another
excel workbook. The source excel worksheet is of the size 102 MB. So
opening
the worksheets in the destination excel workbook and then copying is
taking
too much time. So I tried saving the source worksheet as an excel template
(.xlt file) and then tried adding this template to the destination
workbook
with the following code :

objExcel = New Excel.Application
objBooks = objExcel.Workbooks
..
objBooks.Open("D:\destExcel.xls")
objBooks.Item(1).Sheets.Add( "D:\sourceExcel.xlt")
...

The Sheets.Add method fails in the above piece of code. Does anybody know
the reason ?
I would also like to know if there is an efficient method of copying a
large
sized excel worksheet from one workbook to another without actually having
to
open the source worksheet.

Thanks in anticipation,
CodeKracker.