If you have VB 6.0 or the Developer Version of Office, you should have the
package and deployment wizard. You could "package" your app and distribute
the file with your app.

Note that the ocx must be registered as well as being placed on the machine.
This is done manually user RegSvr32.EXE , but the package and deployment
wizard can perform this function.

Other than that, you would have to program similar functionality.

--
Regards,
Tom Ogilvy

"Brad" wrote in message
...
Good morning.

I used the Calendar Control 9.0 (which I believe came with
Access 2000) in an Excel user form. I want to distribute
this form within my department, but the one person I tried
tested it with, it didn't work, because they didn't have
the control available on her computer.

Now I can manually install the module on her computer, but
I want to give this program to 50 different people, and
would rather not have to manually install the control on
everyone's computer.

Is there a way to do it on demand? Perhaps test for the
module on their computer, and if it's not found, then
perhaps grab it from a network drive?

Thank you for your help.

-Brad