Excel 2007 embedded in VB app

[AGP]

I have a VB6 application that has an OLE container with an embedded Excel
chart. Our office updated to Excel 2007 and now although the app works the
charts looks like crap. Since the app is fairly large my goal is to keep the
devlopement in VB6 but am open to any ideas or suggestions. What i want to
do is:

1. Keep my app in VB6 and find a workaround for the crappy looking charts.
the charts now look very blocky and the grid lines and bars look
like they have bolded outlines. The x-axis also used to show dates that were
sideways and very readable and now they just look like text that is smashed
together.

or

2. Convert my app to VB.NET. However I have yet to find an efficient way to
embed an Excel chart in a .NET app. Any suggestions or tips are welcome.

tia
AGP

 

[Christiano Donke]

You have the dundas charts, and several others nice apps for .net..

also..

..net has the office's interops... that uses the office just like playing...


i know that this conversion is not easy, neither fast...

is your vb6 app shared over network? will it be hard to you to register a
file at all the stations???
if you said no to one of them, you may consider writing a .net class library
that will deal with the chart, write it into an image and the load this
image in the vb6 app..

christiano.

 

[AGP]

My office does not have the budget to buy thrird-party controls so i have to
stick with some native way to display Excel charts within the app. I have no
idea what you mean by office interops. Does that make the charts embeddable
in a .NET app? Are there samples or references i can take a ook at?

Where the app resides does not matter right now. It is an app on a network
but i can easily make it a local app. If you have any specific sites i can
look at please note them.

thanks

AGP

 

[Jon Peltier]

1. While Excel 2007 supposedly has much nicer looking charts, I find they
are worse when embedding or pasting them elsewhere. You could try
simplifying the charts, but it may not have much effect.

2. Can't help you there.

- Jon

 

[Michel Posseth [MCP]]

Hello AGP


Have you ever considered using the free zedgraph control ?
it comes including source and lots of example codes and is written in .Net
( C# )
http://zedgraph.org/wiki/index.php?title=Main_Page

I use the zedgraph control for all my charting and found it to be a verry
easy to use tool

regards

Michel Posseth

 

[AGP]

Thats a great resource. i will keep it in mind for other projects.
However, right now it is important that my standalone Excel workbook
be linked to the app. The code written to interact with the Excel object is
quite
extensive so i would have to rewrite it for the zedgraph. In my case the
charting
is secondary, i need to really link the Excel workbook to the app. We even
have
a license for ComponentOne but that still will not embed a linked chart in
our app. Thanks for the link though.

AGP