Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel and Selecting Entire Workbook...How?
Message
From
29/04/2002 11:38:39
N. Lea
Nic Cross Enterprises
Valencia, California, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Excel and Selecting Entire Workbook...How?
Miscellaneous
Thread ID:
00650432
Message ID:
00650432
Views:
38
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)
Next
Reply
Map
View

Click here to load this message in the networking platform