Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Automation
Message
From
24/02/2011 07:37:12
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Excel Automation
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01501585
Message ID:
01501585
Views:
100
how can open the excel sheet from a specific directory.
while I set the default to the specific path but still and I got error not finding the location

if it is like this I got an error of location
loExcel = CREATEOBJECT("Excel.Application") && Create the Excel object
loWorkbook = loExcel.workbooks.open("cards.xls")
loExcel.Visible = .T. && display Excel

however when I add the path as the following I do not get error. while I need to open from the default original path

loExcel = CREATEOBJECT("Excel.Application") && Create the Excel object
loWorkbook = loExcel.workbooks.open("c:\temp\cards.xls")
loExcel.Visible = .T. && display Excel

Thank You
Next
Reply
Map
View

Click here to load this message in the networking platform