>Hi All,
>
>I'm opening an Excel spreadsheet using following code ...
>
>RELEASE ALL LIKE o*
>oExcel=CREATEOBJECT("Excel.Application")
>oExcel.Visible=.T.
>oWorkbook=oExcel.Workbooks.Open("MyFile.xls")
>
>My workbook has 8 worksheets. What syntax do I use to change the ActiveSheet?
>
>Kind Regards
>
>Jeff
oExcel.Sheets(index or name of the sheet you want to activate).Select()
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.