Control not installed on this Machine error in Excel 2000

[Guest]

I created a Userform that contains an ActiveX calendar control that I can
call from within an Excel 2000 worksheet. It works fine on machines that also
have Access 2000 installed, however on machines without Access, I receive the
error 'A control is not installed on this machine'. I looked in the Knowledge
Base, but it only reference this issue in Excel 97 and the article states
that this was corrected in Office 97 SR 1. Any ideas, please let me know.
Thanks, Richard

 

[Ron de Bruin]

Hi

Read and download it here
http://www.rondebruin.nl/calendar.htm

 

[Guest]

If you go to Tools... Additional Controls from the VBA editor you will see
the list of registered ActiveX controls on that machine. When you click on
the control name you will see at the bottom where the file containing the
control is located. It appears that the calendar control is only on those
Access machines. I do not think the calendar control is part of the standard
Excel 2000 install (I have both Excel and Access 2000 and don't have the
calendar control). Other software on your machine often installs their own
set of controls and you can see and use them if their developer made them
accessible. The control needs to be installed and registered on any computer
that does not have it if you want it to work, but please note that many
ActiveX controls require a license to use/distribute.