I have a need to automate me assinging passwords to say 50 different excel
workbooks. These workbooks have a common format for the filename - it is
DEPTxxx - where xxx is the actual department. I need a program to read the
folder where these are stored, open, place a password on the document and
save the file. Additionally the filename and associated password need to be
recoreded - obviosly. The password would be great it if was auto-generated
or retrieved from an existing sheet of names or something. Does this make
sense?