I'm trying to generate a report using a TreeView control in Excel 2002 (from
the Common Controls 5.0 library). It works fine on my development machine,
but I get a Missing Reference error on any other PC. All the PCs on which
I've tested the report have the exact same version of Office... not sure
what else to try. Any suggestions?

Thanks in advance,
Mike

--


Michael Caputo
Programmer/Database Administrator
Simon Economic Systems Ltd.

The treeview control isn't distributed with Office and is not part of
office. If you have a license to distribute it, you can install it on the
other machines with your installation program.

--
Regards,
Tom Ogilvy


"Mike Caputo" wrote in message
...
I'm trying to generate a report using a TreeView control in Excel 2002
(from
the Common Controls 5.0 library). It works fine on my development
machine,
but I get a Missing Reference error on any other PC. All the PCs on which
I've tested the report have the exact same version of Office... not sure
what else to try. Any suggestions?

Thanks in advance,
Mike

--


Michael Caputo
Programmer/Database Administrator
Simon Economic Systems Ltd.

Wow, that's pretty bad, to say the least.... I definitely wasn't aware that
the TreeView control required a separate license. If that's true, why is it
part of the Windows Common Controls library? Aside from the license issue,
do you know if it's possible to package that DLL and register it
automatically through VBA or VB.NET?

Mike

--


Michael Caputo
Programmer/Database Administrator
Simon Economic Systems Ltd.

"Tom Ogilvy" wrote in message
...
The treeview control isn't distributed with Office and is not part of
office. If you have a license to distribute it, you can install it on the
other machines with your installation program.

--
Regards,
Tom Ogilvy


"Mike Caputo" wrote in message
...
I'm trying to generate a report using a TreeView control in Excel 2002
(from
the Common Controls 5.0 library). It works fine on my development
machine,
but I get a Missing Reference error on any other PC. All the PCs on
which
I've tested the report have the exact same version of Office... not sure
what else to try. Any suggestions?

Thanks in advance,
Mike

--


Michael Caputo
Programmer/Database Administrator
Simon Economic Systems Ltd.

This article would indicate to me that controls hosted in Office Apps
require a design time license as since the apps run in design mode as
opposed to runtime mode. I could be wrong of course:

http://support.microsoft.com/default...b;en-us;172859
ODE97: "You Don't Have a License" Error Using ActiveX Control

Of course, if you haven't gotten that error, then that isn't you problem.

http://support.microsoft.com/?id=171118
OL97: Troubleshooting Solutions That Don't Run on Other Computer
this indicates that you may not require a design time license in later
versions beyond xl97 - so I can't say.

--
Regards,
Tom Ogilvy



"Mike Caputo" wrote in message
...
Wow, that's pretty bad, to say the least.... I definitely wasn't aware
that
the TreeView control required a separate license. If that's true, why is
it
part of the Windows Common Controls library? Aside from the license
issue,
do you know if it's possible to package that DLL and register it
automatically through VBA or VB.NET?

Mike

--


Michael Caputo
Programmer/Database Administrator
Simon Economic Systems Ltd.

"Tom Ogilvy" wrote in message
...
The treeview control isn't distributed with Office and is not part of
office. If you have a license to distribute it, you can install it on
the
other machines with your installation program.

--
Regards,
Tom Ogilvy


"Mike Caputo" wrote in message
...
I'm trying to generate a report using a TreeView control in Excel 2002
(from
the Common Controls 5.0 library). It works fine on my development
machine,
but I get a Missing Reference error on any other PC. All the PCs on
which
I've tested the report have the exact same version of Office... not
sure
what else to try. Any suggestions?

Thanks in advance,
Mike

--


Michael Caputo
Programmer/Database Administrator
Simon Economic Systems Ltd.