Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Category:
COM/DCOM and OLE Automation
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only