I am trying to use OLE Automation in with Excel to bring over data. However, the Automation is blowing an error stating that I need to select a single cell. Is there a part of code that will allow me to select all contents of that page?
Program used: VFP7
#DEFINE xlDBF3 8
oExcel = CreateObject("Excel.Application")
oExcel.Workbooks.Open(.pcapdatapath + "upgrade.xls")
erase sample.dbf
oExcel.ActiveWorkbook.SaveAs(.pcardatapath + "upgrade.dbf", xlDBF3)
oExcel.Activeworkbook.Close(0)