You should be able to use:
ExcelObj.worksheets.count
>I use the following code to open an Excel Workbook from VFP:
>
>ExcelObj = CreateObject('Excel.Application')
>ExcelObj.Visible = .T.
>ExcelObj.Workbooks.Open("D:\TEST.XLS")
>
>Does anyone know of a way to return the number of WORKSHEETS in the open workbook? I can't seem to find an object property that tells me this.
>
>Thanks
Mark Johns