You don't know how happy that makes me. Thanks alot!

John G.

>>By default adding a workbook creates three worksheets. I need to add 5
>>worksheets to this newly created Excel workbook.
>
>Before you add your workbooks do:
>oExcel.SheetsInNewWorkBook = 5
>
>then
>oWorkBook = oExcel.WorkBooks.Add()