COPY TO C:\myfolder\mysheet.XLS TYPE XL5 && XL5 instead of XLS>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.