Control disappeared problem - specifically, the Calendar Control
 

Recently we had an issue with a file that has a form with the Calendar
control on it. Things were working fine until the user got a new computer
and the mscal.ocx file was not on that computer.
Here is what happened when the file was opened:
When the user got to the point where the form with the calendar control
appears, the form appeared WITHOUT the calendar - it was wiped out - and
even when the file was opened on the former computer, where everything
worked fine before, the result was the same. The form appeared without the
Calendar control. So the Calendar control did not load, but was completely
wiped off the form so that it would not run on a host computer that did have
the mscal.ocx file. Can anyone explain why it behaves like this?

How can I make my excel automation "bullet proof" so that the file carries
with it everything it needs and does not depend on a particular file being
present on a host computer?

Is there a "master list" of DLL and OCX files used by VB and VBA that not
only lists the files but also what the files contain, i.e. what
controls/procedures the files support?

Thanks in advance.

TTFN
JMMach