Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Return Excel Graph
Message
 
To
01/10/2001 15:36:45
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00562728
Message ID:
00562736
Views:
31
This message has been marked as the solution to the initial question of the thread.
Renoir,

Yes, it is possible. For example,
1. To run a macro in Excel, you can use RUN method like:

objExcel.Application.Run("Macro1")

2. To display a graph you can use VFP Graph Wizard like:
import from (excelfile) xls && create a VFP table
do (home()+'wizards\wzgraph.app') with "AUTOGRAPH", 4, 2, "Hello",.f.,.f.,.t.,"HI",.f.

Hope it'l help you to start.


>Is it possible to do something like the following:
>
>CreateObject('Excel.Application')
>Open Spreadsheet
>Run Macro
>Return Graph (or graph image) to Foxpro
>Display Graph in form
>
>If so, a couple pointers to get me in the right direction would be cool. Not looking for the total solution, just enough to learn how. Thanks!
>
>Regards, Renoir
Previous
Reply
Map
View

Click here to load this message in the networking platform