Solved

MSGraph Automation

Posted on 2006-07-08
2
275 Views
Last Modified: 2010-08-05
Hi Experts,

Does anyone know if it's possible to create an MSGraph object without the need for powerpoint and excel?

I am familiar with the MSGraph object itself and using it with PowerPoint and Excel but i would like to do something a little different.

My goal for now is to be able to create an MSGraph chart and display it on a form. Another problem i have is how to display it on a form. What control would i need?

The reason i cant get started is because you cannot create a New instance of the MSGraph application and Chart objects in VB.Net.

Any help would be much appreciated.

Cheers,

Tom
0
Comment
Question by:TommyTwoPints
2 Comments
 
LVL 34

Accepted Solution

by:
Sancler earned 500 total points
ID: 17065182
>>
you cannot create a New instance of the MSGraph application and Chart objects in VB.Net.
<<

I'm not sure that it's what you want, but if you add a .Com reference to Microsoft Office Chart - whichever version/s you have - you should be able to drag it from the Components Tag on the Toolbox onto a form.  You are then given the option to select a datasource or hardcode values and choose a variety of graph/chart files with the Active-X Edit command at the bottom of the properties window.

I've only ever used it (Version 10, in VB.NET 2003) for a "picture", so have no experience of dynamic coding with it.  But I wondered if it might help you.

Roger
0
 
LVL 3

Author Comment

by:TommyTwoPints
ID: 17066819
Hi Roger,

That is excellent; just what i need,

Thanks.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Modal Popup Extender control 1 50
SqlServer no dupes 25 41
VB.net Is there code behind PowerPivot 2 43
Web page design problem 3 12
Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question