>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()
Thank Della and Tamar, they trained me via their book...
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope