I have invoices I must send and receive each month. When I prepare them, they are saved in a folder unprotected. I then have a macro that prepares a list for my manager to check the figures. If she agrees, I open each one and send. The VBA for that, re-protects the file and sends it to the appropriate employee.
They "digitally" sign it by completing the name and date field, and send it back to me, still protected. I affix SIGNED to the end of the filename and place all in a "Signed" folder.
What I need is a routine that will batch open the files from a list of the passwords (perhaps in a vlookup), and then prints the appropriate page.
Is it possible on the open dialog to have a macro run to open with the appropriate password inserted into the dialog?
Bookmarks