467,885 Members | 1,293 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,885 developers. It's quick & easy.

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
Aug 18 '08 #1
  • viewed: 2890
Share:
9 Replies
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" <si**********@softhome.netescreveu na mensagem
news:Ax****************@nlpi069.nbdc.sbc.com...
>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

Aug 18 '08 #2
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

"Christiano Donke" <cd****@digiexpress.com.brwrote in message
news:uZ*************@TK2MSFTNGP06.phx.gbl...
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" <si**********@softhome.netescreveu na mensagem
news:Ax****************@nlpi069.nbdc.sbc.com...
>>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


Aug 18 '08 #3
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
"AGP" <si**********@softhome.netwrote in message
news:Ax****************@nlpi069.nbdc.sbc.com...
>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

Aug 18 '08 #4
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" <si**********@softhome.netschreef in bericht
news:lX******************@nlpi069.nbdc.sbc.com...
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

"Christiano Donke" <cd****@digiexpress.com.brwrote in message
news:uZ*************@TK2MSFTNGP06.phx.gbl...
>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" <si**********@softhome.netescreveu na mensagem
news:Ax****************@nlpi069.nbdc.sbc.com...
>>>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



Aug 18 '08 #5
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

"Michel Posseth [MCP]" <MS**@posseth.comwrote in message
news:uJ**************@TK2MSFTNGP05.phx.gbl...
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" <si**********@softhome.netschreef in bericht
news:lX******************@nlpi069.nbdc.sbc.com...
>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

"Christiano Donke" <cd****@digiexpress.com.brwrote in message
news:uZ*************@TK2MSFTNGP06.phx.gbl...
>>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" <si**********@softhome.netescreveu na mensagem
news:Ax****************@nlpi069.nbdc.sbc.com.. .
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



Aug 19 '08 #6
Have you hardcoded all of the chart parameters? I wonder if the defaults
changed from 2003 to 2007 (autosize, font size, orientation, etc) in ways
that you could correct by manually setting all chart parameters, even if
that is a big pain.

Alternatively, have you looked at exporting the chart from Excel as a
graphic (bitmap or jpeg) instead of a chart object, and just importing the
graphic in your app (even if you had to do it multiple times to refresh the
graphic)? I haven't upgraded to O2007 yet (because of all of the reports of
Excel problems) but exporting a graph as an image is fairly easy in O2003
(google is your friend).

HTH,
Keith

"AGP" <si**********@softhome.netwrote in message
news:4_******************@nlpi067.nbdc.sbc.com...
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

"Michel Posseth [MCP]" <MS**@posseth.comwrote in message
news:uJ**************@TK2MSFTNGP05.phx.gbl...
>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" <si**********@softhome.netschreef in bericht
news:lX******************@nlpi069.nbdc.sbc.com. ..
>>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

"Christiano Donke" <cd****@digiexpress.com.brwrote in message
news:uZ*************@TK2MSFTNGP06.phx.gbl...
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" <si**********@softhome.netescreveu na mensagem
news:Ax****************@nlpi069.nbdc.sbc.com. ..
>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
>




Sep 8 '08 #7
On Sep 8, 4:07*pm, "ker_01" <ker...@newsgroup.nospamwrote:
Have you hardcoded all of the chart parameters? I wonder if the defaults
changed from 2003 to2007(autosize, font size, orientation, etc) in ways
that you could correct by manually setting all chart parameters, even if
that is a big pain.

Alternatively, have you looked at exporting the chart fromExcelas a
graphic (bitmap or jpeg) instead of a chart object, and just importing the
graphic in yourapp(even if you had to do it multiple times to refresh the
graphic)? I haven't upgraded to O2007 yet (because of all of the reports ofExcelproblems) but exporting a graph as an image is fairly easy in O2003
(google is your friend).

HTH,
Keith

"AGP" <sindizzy....@softhome.netwrote in message

news:4_******************@nlpi067.nbdc.sbc.com...
Thats a great resource. i will keep it in mind for other projects.
However, right now it is important that my standaloneExcelworkbook
be linked to theapp. The code written to interact with theExcelobject
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 theExcelworkbook to theapp. We even
have
a license for ComponentOne but that still will not embed a linked chartin
ourapp. Thanks for the link though.
AGP
"Michel Posseth [MCP]" <M...@posseth.comwrote in message
news:uJ**************@TK2MSFTNGP05.phx.gbl...
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" <sindizzy....@softhome.netschreef in bericht
news:lX******************@nlpi069.nbdc.sbc.com. ..
My office does not have the budget to buy thrird-party controls so i
have to stick with some native way to displayExcelcharts within the
app. I have no idea what you mean by office interops. Does that make the
charts embeddable in a .NETapp? Are there samples or references i can
take a ook at?
>Where theappresides does not matter right now. It is anappon a
network but i can easily make it a localapp. If you have any specific
sites i can look at please note them.
>thanks
>AGP
>"Christiano Donke" <cdo...@digiexpress.com.brwrote in message
news:uZ*************@TK2MSFTNGP06.phx.gbl...
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 vb6appshared 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 vb6app..
>>christiano.
>>"AGP" <sindizzy....@softhome.netescreveu na mensagem
news:Ax****************@nlpi069.nbdc.sbc.com. ..
I have a VB6 application that has an OLE container with anembedded
Excelchart. Our office updated toExcel2007and now although theapp
works the charts looks like crap. Since theappis 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 myappin 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 myapptoVB.NET. However I have yet to find an efficient
way to embed anExcelchart in a .NETapp. Any suggestions or tips are
welcome.
>>>tia
AGP
I didn't know there was any more follow ups to my inquiry. anyways i
do not hard code any chart parameters and in fact I created a small
VB6 project with the OLE container and linked an existing Excel
workbook and no code at all it still looks crappy. That leads me to
believe that MS just changed the interaction with an OLE container. I
think that its not even supported. That's ok but what is the
alternative that MS has suggested? I cant find an alternative for VB6
or VB.Net. if anyone knows then I would love to check it out.

But you suggest a good idea. About going through my process and then
exporting the chart to a bitmap and then displaying the bitmap in the
app as it were an interactive chart. I'll have to test that and see
how that pans out.

AGP

Thats an interesting idea.
Oct 14 '08 #8
On Oct 14, 5:15*pm, DIOS <sindi...@gmail.comwrote:
On Sep 8, 4:07*pm, "ker_01" <ker...@newsgroup.nospamwrote:
Have you hardcoded all of the chart parameters? I wonder if the defaults
changed from 2003 to2007(autosize, font size, orientation, etc) in ways
that you could correct by manually setting all chart parameters, even if
that is a big pain.
Alternatively, have you looked at exporting the chart fromExcelas a
graphic (bitmap or jpeg) instead of a chart object, and just importing the
graphic in yourapp(even if you had to do it multiple times to refresh the
graphic)? I haven't upgraded to O2007 yet (because of all of the reports ofExcelproblems) but exporting a graph as an image is fairly easy in O2003
(google is your friend).
HTH,
Keith
"AGP" <sindizzy....@softhome.netwrote in message
news:4_******************@nlpi067.nbdc.sbc.com...
Thats a great resource. i will keep it in mind for other projects.
However, right now it is important that my standaloneExcelworkbook
be linked to theapp. The code written to interact with theExcelobject
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 theExcelworkbook to theapp. We even
have
a license for ComponentOne but that still will not embed a linked chart in
ourapp. Thanks for the link though.
AGP
"Michel Posseth [MCP]" <M...@posseth.comwrote in message
>news:uJ**************@TK2MSFTNGP05.phx.gbl...
>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" <sindizzy....@softhome.netschreef in bericht
>>news:lX******************@nlpi069.nbdc.sbc.com.. .
>>My office does not have the budget to buy thrird-party controls so i
>>have to stick with some native way to displayExcelcharts within the
>>>app. I have no idea what you mean by office interops. Does that makethe
>>charts embeddable in a .NETapp? Are there samples or references i can
>>take a ook at?
>>Where theappresides does not matter right now. It is anappon a
>>network but i can easily make it a localapp. If you have any specific
>>sites i can look at please note them.
>>thanks
>>AGP
>>"Christiano Donke" <cdo...@digiexpress.com.brwrote in message
>>>news:uZ*************@TK2MSFTNGP06.phx.gbl...
>>>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 vb6appshared 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 vb6app..
>>>christiano.
>>>"AGP" <sindizzy....@softhome.netescreveu na mensagem
>>>>news:Ax****************@nlpi069.nbdc.sbc.com.. .
>>>>>I have a VB6 application that has an OLE container with anembedded
>>>>>Excelchart. Our office updated toExcel2007and now although theapp
>>>>>works the charts looks like crap. Since theappis 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 myappin 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 myapptoVB.NET. However I have yet to find an efficient
>>>>way to embed anExcelchart in a .NETapp. Any suggestions or tips are
>>>>welcome.
>>>>tia
>>>>AGP

I didn't know there was any more follow ups to my inquiry. anyways i
do not hard code any chart parameters and in fact I created a small
VB6 project with the OLE container and linked an existingExcel
workbook and no code at all it still looks crappy. That leads me to
believe that MS just changed the interaction with an OLE container. I
think that its not even supported. That's ok but what is the
alternative that MS has suggested? I cant find an alternative for VB6
orVB.Net. if anyone knows then I would love to check it out.

But you suggest a good idea. About going through my process and then
exporting the chart to a bitmap and then displaying the bitmap in theappas it were an interactive chart. I'll have to test that and see
how that pans out.

AGP

Thats an interesting idea.
That actually works pretty well. The bitmap is alot better than tthe
OLE representation. The downside is that your app has to clean up the
temporary bitmaps but that is not that big of a deal and the rendering
and loading of the bitmap makes the process take a couple of extra
seconds. for me its not a bad sacrifice to display a better
representation of the chart embedded in my app.

AGP
Oct 21 '08 #9

"DIOS" <si******@gmail.comwrote in message
news:e2**********************************@b38g2000 prf.googlegroups.com...
On Oct 14, 5:15 pm, DIOS <sindi...@gmail.comwrote:
On Sep 8, 4:07 pm, "ker_01" <ker...@newsgroup.nospamwrote:
Have you hardcoded all of the chart parameters? I wonder if the defaults
changed from 2003 to2007(autosize, font size, orientation, etc) in ways
that you could correct by manually setting all chart parameters, even if
that is a big pain.
Alternatively, have you looked at exporting the chart fromExcelas a
graphic (bitmap or jpeg) instead of a chart object, and just importing
the
graphic in yourapp(even if you had to do it multiple times to refresh
the
graphic)? I haven't upgraded to O2007 yet (because of all of the reports
ofExcelproblems) but exporting a graph as an image is fairly easy in
O2003
(google is your friend).
HTH,
Keith
"AGP" <sindizzy....@softhome.netwrote in message
news:4_******************@nlpi067.nbdc.sbc.com...
Thats a great resource. i will keep it in mind for other projects.
However, right now it is important that my standaloneExcelworkbook
be linked to theapp. The code written to interact with theExcelobject
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 theExcelworkbook to theapp. We
even
have
a license for ComponentOne but that still will not embed a linked
chart in
ourapp. Thanks for the link though.
AGP
"Michel Posseth [MCP]" <M...@posseth.comwrote in message
>news:uJ**************@TK2MSFTNGP05.phx.gbl...
>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" <sindizzy....@softhome.netschreef in bericht
>>news:lX******************@nlpi069.nbdc.sbc.com.. .
>>My office does not have the budget to buy thrird-party controls so i
>>have to stick with some native way to displayExcelcharts within the
>>>app. I have no idea what you mean by office interops. Does that make
>>>the
>>charts embeddable in a .NETapp? Are there samples or references i
>>can
>>take a ook at?
>>Where theappresides does not matter right now. It is anappon a
>>network but i can easily make it a localapp. If you have any
>>specific
>>sites i can look at please note them.
>>thanks
>>AGP
>>"Christiano Donke" <cdo...@digiexpress.com.brwrote in message
>>>news:uZ*************@TK2MSFTNGP06.phx.gbl...
>>>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 vb6appshared 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 vb6app..
>>>christiano.
>>>"AGP" <sindizzy....@softhome.netescreveu na mensagem
>>>>news:Ax****************@nlpi069.nbdc.sbc.com.. .
>>>>>I have a VB6 application that has an OLE container with anembedded
>>>>>Excelchart. Our office updated toExcel2007and now although theapp
>>>>>works the charts looks like crap. Since theappis 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 myappin 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 myapptoVB.NET. However I have yet to find an efficient
>>>>way to embed anExcelchart in a .NETapp. Any suggestions or tips
>>>>are
>>>>welcome.
>>>>tia
>>>>AGP

I didn't know there was any more follow ups to my inquiry. anyways i
do not hard code any chart parameters and in fact I created a small
VB6 project with the OLE container and linked an existingExcel
workbook and no code at all it still looks crappy. That leads me to
believe that MS just changed the interaction with an OLE container. I
think that its not even supported. That's ok but what is the
alternative that MS has suggested? I cant find an alternative for VB6
orVB.Net. if anyone knows then I would love to check it out.

But you suggest a good idea. About going through my process and then
exporting the chart to a bitmap and then displaying the bitmap in theappas
it were an interactive chart. I'll have to test that and see
how that pans out.

AGP

Thats an interesting idea.
That actually works pretty well. The bitmap is alot better than tthe
OLE representation. The downside is that your app has to clean up the
temporary bitmaps but that is not that big of a deal and the rendering
and loading of the bitmap makes the process take a couple of extra
seconds. for me its not a bad sacrifice to display a better
representation of the chart embedded in my app.

AGP

Glad it worked out, and thanks for replying to the group with your insights
about the OLE container- while I haven't upgraded yet, I will eventually,
and knowing to keep an eye on that will surely save me some troubleshooting
down the line.
:)
Keith
Oct 27 '08 #10

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Allison Bailey | last post: by
12 posts views Thread by slinky | last post: by
15 posts views Thread by =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.