>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()
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope