You will either have to get your IT people to do it or
write a script to do this for you.
The script is simple a text file ending in .VBS instead
of text , wnd the text in the file will be almost
identical to
VB
COPY x Y
where x will be the full path and name of the control and
Y is the full name and path fo the destination.
We do this remotely, since our network allows us to
connect to an networked pc, so long as we know the pac'c
name.
so a network pc may be netwk12
the C drive, from MY pc is \\netwk12\c$
from there I can navigate wherever.
so with a list of pc names on my sheet, a simple loop
allows me to do exactly what you need:
for rw= 1 to 50
targetPC = cells(rw,1)
copy Source,targetpc & subPathandName & CopyFileName
next
HTH
Patrick Molloy
Microsoft Excel MVP
-----Original 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
.