My Excel97 at work will not recognize already
installed ActiveX components (i.e. c:\winnt\system32
\comdlg32.dll). My Excel97 at home does! My current
thinking is that if I could obtain a custom written
activeX control and install it, everything would be okay.

Surely somewhere there is a website that contains
hundreds/thousands of ActiveX controls for Excel97. My
question is where/what address?

Thanks in advance,

David Fixemer

"David Fixemer" wrote in message
...
My Excel97 at work will not recognize already
installed ActiveX components (i.e. c:\winnt\system32
\comdlg32.dll). My Excel97 at home does! My current
thinking is that if I could obtain a custom written
activeX control and install it, everything would be okay.


I assume your problem is with using these controls in the
design environment, i.e. adding them too a Userform rather
than using a predefined userform in an application. This
is a licensing issue. Essentially you need either Visual Studio
Professional or the Developer Edition of Office to
use these controls in design mode but any office installation
may use them.

Surely somewhere there is a website that contains
hundreds/thousands of ActiveX controls for Excel97. My
question is where/what address?


There is no single source for such contols. While Microsoft
have a standard set that ships with Windows there are
extensions that go with the Development platforms and
anyone with a compiler can develop their own which
often require a license to be purchased.

Keith

Keith,

Your assumption that I'm "using these controls in the
design environment" is indeed correct and it does appear
to be a licensing issue. My PC at home does have Visual
Studio 6.0. I'm confused when you say "but any office
installation may use them." I'm kind of looking for a
single activeX control that someone developed (Free of
course). It seems that I should be able to install this
into my registry and use it in my Excel97 design
environment?

Thanks for your response,

David Fixemer

http://ccrp.mvps.org/

--
Regards,
Tom Ogilvy


"David Fixemer" wrote in message
...
Keith,

Your assumption that I'm "using these controls in the
design environment" is indeed correct and it does appear
to be a licensing issue. My PC at home does have Visual
Studio 6.0. I'm confused when you say "but any office
installation may use them." I'm kind of looking for a
single activeX control that someone developed (Free of
course). It seems that I should be able to install this
into my registry and use it in my Excel97 design
environment?

Thanks for your response,

David Fixemer

"David Fixemer" wrote in message
...
Keith,

Your assumption that I'm "using these controls in the
design environment" is indeed correct and it does appear
to be a licensing issue. My PC at home does have Visual
Studio 6.0. I'm confused when you say "but any office
installation may use them."

I mean that if you develop your user forms on the machine
that had Visual Studio you may use them in an add-in on a
machine which doesnot

I'm kind of looking for a
single activeX control that someone developed (Free of
course). It seems that I should be able to install this
into my registry and use it in my Excel97 design
environment?


But what do you want this control to do ?

There are THOUSANDS of them , you could
even develop one yourself with VS6

Keith