FWIW:
Just thought I'd share this...


The usage scenario that spawned this process is as follows:

Client-specific tasking to:
a. distribute updated product templates to field reps;
This uses a single source file, multiple target files;
Each field rep's file has an open password, as it also had a 'Notes'
sheet that usually contained confidential rep-specific info;
Each field rep accessed their update file via remote login to the
server.

b. collect previous period files from field reps;
Each field rep uploaded their current working file weekly;
- (this could be during downloading of new templates)
This uses a single target file, multiple source files.

c. distribute various sheets from various files to various staff in
various departments;
This uses various source/target files.

Notes:
The 'Admin' user has restricted access according to their specific need, and so
this was managed in the app via login credentials.

Both field reps and office staff use the same addin. Access to functionality is
controlled via login credentials.

All source/target file require an open password; -this was also stored in the
appropriate Src/Tgt table listing.

All tasks are menu-driven.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion