Using a macro to enter a password
Posted by Melanie on July 30, 2001 9:19 AM
I have a spreadsheet that I update daily for about 200 users. The spreadsheet is password protected so that no one except me can update it.
I have a fine macro that FTPs and opens files and updates data, etc. It has cut the work down from 2 hrs a day to about 15 min. In order to cut that down even more, I would like my macro spreadsheet to open the working spreadsheet.
Is there a way that I can have the macro on my macro spreadsheet open the working spreadsheet and enter the password for the working spreadsheet?