Hello,

I am developing a VB program which could use the charting capabilities
of Excel. I have worked with other charts and I cannot find any chart which
duplicates the 2D surface chart in the manner that Excel does. I would like
to use this chart as an activex component in a VB application, but cannot
figure out who's control it is or if it is purchaseable from MS or what??

Anybody know the answer to this question?

Thanks in advance!

Andrew Mueller

Andrew -

If you can count on the users having Excel, you could automate Excel
from VB to draw the chart. There must be dozens of examples on the web
that show how to do this.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Andrew Mueller wrote:

> Hello,
>
> I am developing a VB program which could use the charting capabilities
> of Excel. I have worked with other charts and I cannot find any chart which
> duplicates the 2D surface chart in the manner that Excel does. I would like
> to use this chart as an activex component in a VB application, but cannot
> figure out who's control it is or if it is purchaseable from MS or what??
>
> Anybody know the answer to this question?
>
> Thanks in advance!
>
> Andrew Mueller
>
>

Unfortunately, this has to be a stand alone activex that I have to either
wrapper or automate from within another VBA container. I prefer to put an
activex wrapper around a control so that I can add properties, methods, and
events... So that the end user can use simple code from within the
container.


Thanks, though.

Andrew Mueller


"Jon Peltier" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Andrew -
>
> If you can count on the users having Excel, you could automate Excel
> from VB to draw the chart. There must be dozens of examples on the web
> that show how to do this.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> Andrew Mueller wrote:
>
> > Hello,
> >
> > I am developing a VB program which could use the charting
capabilities
> > of Excel. I have worked with other charts and I cannot find any chart
which
> > duplicates the 2D surface chart in the manner that Excel does. I would
like
> > to use this chart as an activex component in a VB application, but
cannot
> > figure out who's control it is or if it is purchaseable from MS or
what??
> >
> > Anybody know the answer to this question?
> >
> > Thanks in advance!
> >
> > Andrew Mueller
> >
> >
>

Andrew -

Yeah, that's all stuff I know I should be doing.... Are the OWC charts
any good?

- Jon

Andrew Mueller wrote:

> Unfortunately, this has to be a stand alone activex that I have to either
> wrapper or automate from within another VBA container. I prefer to put an
> activex wrapper around a control so that I can add properties, methods, and
> events... So that the end user can use simple code from within the
> container.
>
>
> Thanks, though.
>
> Andrew Mueller
>
>
> "Jon Peltier" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>
>>Andrew -
>>
>>If you can count on the users having Excel, you could automate Excel
>>from VB to draw the chart. There must be dozens of examples on the web
>>that show how to do this.
>>
>>- Jon
>>-------
>>Jon Peltier, Microsoft Excel MVP
>>Peltier Technical Services
>>Tutorials and Custom Solutions
>>http://PeltierTech.com/
>>_______
>>
>>Andrew Mueller wrote:
>>
>>
>>>Hello,
>>>
>>> I am developing a VB program which could use the charting
>
> capabilities
>
>>>of Excel. I have worked with other charts and I cannot find any chart
>
> which
>
>>>duplicates the 2D surface chart in the manner that Excel does. I would
>
> like
>
>>>to use this chart as an activex component in a VB application, but
>
> cannot
>
>>>figure out who's control it is or if it is purchaseable from MS or
>
> what??
>
>>>Anybody know the answer to this question?
>>>
>>>Thanks in advance!
>>>
>>>Andrew Mueller
>>>
>>>
>>
>
>

Might work with Office Web Components except that I need to be able to
program with earlier versions of Visual Studio (6.0) so that the end result
does not require .NET to be loaded. Plus.. I don't want the end user to
have to load OWC, I don't know if they can be separated out, or if runtime
royalties are free, etc... Just too many ' I don't knows ' to begin down
that path.

Andrew


"Jon Peltier" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Andrew -
>
> Yeah, that's all stuff I know I should be doing.... Are the OWC charts
> any good?
>
> - Jon
>
> Andrew Mueller wrote:
>
> > Unfortunately, this has to be a stand alone activex that I have to
either
> > wrapper or automate from within another VBA container. I prefer to put
an
> > activex wrapper around a control so that I can add properties, methods,
and
> > events... So that the end user can use simple code from within the
> > container.
> >
> >
> > Thanks, though.
> >
> > Andrew Mueller
> >
> >
> > "Jon Peltier" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> >
> >>Andrew -
> >>
> >>If you can count on the users having Excel, you could automate Excel
> >>from VB to draw the chart. There must be dozens of examples on the web
> >>that show how to do this.
> >>
> >>- Jon
> >>-------
> >>Jon Peltier, Microsoft Excel MVP
> >>Peltier Technical Services
> >>Tutorials and Custom Solutions
> >>http://PeltierTech.com/
> >>_______
> >>
> >>Andrew Mueller wrote:
> >>
> >>
> >>>Hello,
> >>>
> >>> I am developing a VB program which could use the charting
> >
> > capabilities
> >
> >>>of Excel. I have worked with other charts and I cannot find any chart
> >
> > which
> >
> >>>duplicates the 2D surface chart in the manner that Excel does. I would
> >
> > like
> >
> >>>to use this chart as an activex component in a VB application, but
> >
> > cannot
> >
> >>>figure out who's control it is or if it is purchaseable from MS or
> >
> > what??
> >
> >>>Anybody know the answer to this question?
> >>>
> >>>Thanks in advance!
> >>>
> >>>Andrew Mueller
> >>>
> >>>
> >>
> >
> >
>