473,326 Members | 2,010 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

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
9 3199
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: Allison Bailey | last post by:
Hi Folks, I'm a brand new Python programmer, so please point me in the right direction if this is not the best forum for this question.... I would like to open an existing MS Excel spreadsheet...
0
by: ghanley | last post by:
I have searched the web all day for a lead on this. I have found how to control the Graph object mut not the embedded excel unbound object frame. I am trying to chart the data below on one...
3
by: GH | last post by:
Does anyone know how I can access (using OleDbConnection, I presume) a spreadsheet embedded in a cell of another spreadsheet (with vb.net)? Thanks, GH
0
by: Bill Fallon | last post by:
I am developing a VB.Net application with VS 2005 that opens an Excel workbook and populates the worksheet with data. I started developing the application with Office 2007 installed on my Vista...
2
by: Ch Pravin | last post by:
Hi All: I am having the following xml which i need to convert to excel using xslt. Please help me out. Afghanistan.xml <?xml version="1.0" encoding="utf-16"?> <Languages...
12
by: slinky | last post by:
Can an Excel spreadsheet or a section of one be embedded into an Access form and serve as a subform from which other parts of the Access form can get data? Thanks!
15
by: =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= | last post by:
Hi All, We are in the process of Upgrade Excel 2003 (Office 2003) to Excel 2007 (Office 2007) for one of web application. This web application is using Excel (Pivot Table) reports. With Excel...
2
budigila
by: budigila | last post by:
Hiya peeps, Okies, I have been trying to work this out for a while now to no avail... I am a beginner to this whole coding thing but have made great strides in my project. Basically what I am...
2
DAF LAD
by: DAF LAD | last post by:
Hi all, I have been running a database in Access 2003 for may years now. One of the update functions that I do imports an excel spreadsheet into a table in my database. I have this...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.