473,695 Members | 3,220 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 3248
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**********@s ofthome.netescr eveu na mensagem
news:Ax******** ********@nlpi06 9.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****@digiexp ress.com.brwrot e in message
news:uZ******** *****@TK2MSFTNG P06.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**********@s ofthome.netescr eveu na mensagem
news:Ax******** ********@nlpi06 9.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**********@s ofthome.netwrot e in message
news:Ax******** ********@nlpi06 9.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**********@s ofthome.netschr eef in bericht
news:lX******** **********@nlpi 069.nbdc.sbc.co m...
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****@digiexp ress.com.brwrot e in message
news:uZ******** *****@TK2MSFTNG P06.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**********@s ofthome.netescr eveu na mensagem
news:Ax******* *********@nlpi0 69.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.c omwrote in message
news:uJ******** ******@TK2MSFTN GP05.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**********@s ofthome.netschr eef in bericht
news:lX******** **********@nlpi 069.nbdc.sbc.co m...
>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****@digiexp ress.com.brwrot e in message
news:uZ******* ******@TK2MSFTN GP06.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**********@s ofthome.netescr eveu na mensagem
news:Ax****** **********@nlpi 069.nbdc.sbc.co m...
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**********@s ofthome.netwrot e in message
news:4_******** **********@nlpi 067.nbdc.sbc.co m...
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.c omwrote in message
news:uJ******** ******@TK2MSFTN GP05.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**********@s ofthome.netschr eef in bericht
news:lX******* ***********@nlp i069.nbdc.sbc.c om...
>>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****@digiexp ress.com.brwrot e in message
news:uZ****** *******@TK2MSFT NGP06.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**********@s ofthome.netescr eveu na mensagem
news:Ax***** ***********@nlp i069.nbdc.sbc.c om...
>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
>suggestion s. 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...@newsgro up.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....@s ofthome.netwrot e in message

news:4_******** **********@nlpi 067.nbdc.sbc.co m...
Thats a great resource. i will keep it in mind for other projects.
However, right now it is important that my standaloneExcel workbook
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 theExcelworkboo k 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.c omwrote in message
news:uJ******** ******@TK2MSFTN GP05.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....@s ofthome.netschr eef in bericht
news:lX******* ***********@nlp i069.nbdc.sbc.c om...
My office does not have the budget to buy thrird-party controls so i
have to stick with some native way to displayExcelcha rts 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...@digiexp ress.com.brwrot e in message
news:uZ****** *******@TK2MSFT NGP06.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....@s ofthome.netescr eveu na mensagem
news:Ax***** ***********@nlp i069.nbdc.sbc.c om...
I have a VB6 application that has an OLE container with anembedded
Excelchar t. 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...@newsgro up.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....@s ofthome.netwrot e in message
news:4_******** **********@nlpi 067.nbdc.sbc.co m...
Thats a great resource. i will keep it in mind for other projects.
However, right now it is important that my standaloneExcel workbook
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 theExcelworkboo k 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.c omwrote in message
>news:uJ******* *******@TK2MSFT NGP05.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....@s ofthome.netschr eef in bericht
>>news:lX****** ************@nl pi069.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 displayExcelcha rts 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...@digiexp ress.com.brwrot e in message
>>>news:uZ***** ********@TK2MSF TNGP06.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....@s ofthome.netescr eveu na mensagem
>>>>news:Ax**** ************@nl pi069.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
>>>>>suggestion s. 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******** *************** ***********@b38 g2000prf.google groups.com...
On Oct 14, 5:15 pm, DIOS <sindi...@gmail .comwrote:
On Sep 8, 4:07 pm, "ker_01" <ker...@newsgro up.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....@s ofthome.netwrot e in message
news:4_******** **********@nlpi 067.nbdc.sbc.co m...
Thats a great resource. i will keep it in mind for other projects.
However, right now it is important that my standaloneExcel workbook
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 theExcelworkboo k 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.c omwrote in message
>news:uJ******* *******@TK2MSFT NGP05.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....@s ofthome.netschr eef in bericht
>>news:lX****** ************@nl pi069.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 displayExcelcha rts 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...@digiexp ress.com.brwrot e in message
>>>news:uZ***** ********@TK2MSF TNGP06.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....@s ofthome.netescr eveu na mensagem
>>>>news:Ax**** ************@nl pi069.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
>>>>>suggestion s. 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
35549
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 and extract information from specific worksheets and cells. I'm not really sure how to get started with this process. I ran the COM Makepy utility from my PythonWin (IDE from ActiveSTate),
0
2918
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 chart that comes from a query. I have managed to do this in excel and embedding the worksheet. Program 2005 2006 2007 2008 2009 2010
3
1692
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
4127
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 OS, but after I discovered that it won't run on a system with Office 2003, I uninstalled Office 2007 and installed Office 2003. I reset the reference in .Net to the Microsoft Excel 11.0 Object Library. The application works fine from the ..Net...
2
8913
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 BuildVersion="1,5,0815,0 " CountryName="Afghanistan" > <Language locale="English">
12
3801
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
5348
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 2003 application (Reports) works ok. But when Office 2003 is upgraded to Office 2007 Excel reports stops working. It Log the error “Exception from HRESULT: 0x800A03EC.” In database.
2
5187
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 trying to do is to convert an .xml using a .xsl to and using a java script to output it into a readable format within excel. I have been able to successfully use a javascript to combine my .xml and .xsl but cannot figure out how to have it output to...
2
1845
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 automatically working from a command button through vb code. Recently I have upgraded my office suite to the 2007 edition. Now when I try to run this command from this button I get an error code saying that something is missing (in the access file nothing I...
0
8582
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9122
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9001
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8860
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8832
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7672
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development projectplanning, coding, testing, and deploymentwithout human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5841
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4587
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3018
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.