>I have a small Excel automation program that generates a data set in VFP and then copies the data to an Excel spreadsheet. I than create a workbook object and add a chart to it.
>

>COPY TO C:\myfolder\mysheet.XLS TYPE XLS
>oWorkBook = GETOBJECT("C:\myfolder\mysheet.xls")
>oChart1=oWorkBook.Charts.Add()	
>

>This works fine in Excel 2003 (on XP) but crashes in Excel 2010 (on a W7 OS) on the 3rd line with Error message: Object OWORKBOOK is not found.
>
>Any help appreciated.
>
>Barry Sutton

I do the following:

LOCAL loExcel AS Excel.Application
LOCAL loWorkbook AS Excel.Workbook
LOCAL loWorksheet AS Excel.Worksheet
*
loExcel = CREATEOBJECT("Excel.Application")
loWorkbook = loExcel.Workbooks.Open("C:\myfolder\mysheet.xls")
loWorksheet = loWorkbook.ActiveSheet
*
loWorkbook.Charts.Add()
*
loWorkbook.Save()
*
loExcel.Visible = .T.