View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
patrick molloy patrick molloy is offline
external usenet poster
 
Posts: 391
Default Calendar Control 9.0

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
.