Save as from a list
I have one workbook that I create every month and distribute to employees.
Every employee has their own version of this workbook.
Normally, I create the blank workbook and do a File-SaveAs (their operator
#/name).
Instead of doing this 30 times and saving as each persons name/number, is it
possible to key a list of their names and run a macro (or something else) to
automatically create a file with each persons name???
|