Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Making a graph
Message
From
30/06/2001 10:42:00
 
 
To
30/06/2001 10:32:12
General information
Forum:
Visual FoxPro
Category:
Object Oriented Programming
Title:
Miscellaneous
Thread ID:
00525325
Message ID:
00525598
Views:
21
>Thanks Cetin, but I dont know anything about it.
>I wonder if you tell me where can I get it and How to use.

You can use Excel and control it through COM Automation.
oExcel = CreateObject("Excel.application")
Now you have a reference to Excel to do anything you want. To learn how to create grap[h, go to Excel, turn the macro record on, put some dat, create a graph, then turn macro recorder off. You can now look at the code (Alt-F11) and see the VBA code produced. It should be easy to translate that to VFP. For more info on Excel's DOM, look a the Office CHM or in MSDN (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeomg/html/deovrobjectmodelguide.asp)

I recommend you look at the book "Microsoft Office Automation with Visual FoxPro" by Tamar Granor and Della Martin, Hentzenwerke, ISBN 0-9655093-0-3 that gives you good examples and excelent information.


Another option that Çetin mentioned is MSGraph. There are examples of how to use it here in the UT downloads and messages sections. Do a search on MSGraph.

Example: Message #523940

Also, MSDN and Microsoft KnowledgeBase have information:

HOWTO: Automate An Embedded MSGraph Object with Visual Basic
http://support.microsoft.com/support/kb/articles/Q244/5/89.asp

http://search.support.microsoft.com/kb/c.asp?ln=en-us&sd=gn


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Reply
Map
View

Click here to load this message in the networking platform