>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.
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.