>HI,
>What is property I need to use in order to change the name of Excel Sheet (Sheet1, Sheet2, ect.)
>
>THank you,
>Christian
I use the following code to name the sheet I am working with:
loExcel = CreateObject("Excel.Application")
loExcel.SheetsInNewWorkBook = 9
loWorkBook = loExcel.Workbooks.Add()
loWorkSheet = loWorkBook.Worksheets[1]
loWorkSheet.Name = 'CCA'
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope