Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Run excel from FoxPro
Message
From
09/07/1999 13:03:10
 
 
To
09/07/1999 12:47:23
Coann Teng
Computer Infobase System S/B
Kuala Lumpur, Malaysia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00239495
Message ID:
00239506
Views:
8
>Can i run Excel from FoxPro Code and Open a file using FoxPro Code also?
>>Can i run Excel from FoxPro Code and Open a file using FoxPro Code also?

There are at least two ways to do this; either launch Excel with the VFP native RUN command, passing the name of the spreadsheet to open on the command line, or use can use Excel via OLE Auomation using CREATEOBJ() or the equivalent to open an instance (for example, if Excel is instaled, you can access it's standard application interface with CREATEOBJ('Excel.Application'), and then use the published methods and properties through the object that you create) and drive it from VFP directly.

There may be a DDE interface available as well.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Reply
Map
View

Click here to load this message in the networking platform