MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?


Posted by Jerid on July 30, 2001 10:41 AM

Melanie, try this.

Workbooks.Open FileName:="C:\Temp\Book1.xls", Password:="test", WriteResPassword:="test"

Replace "C:\Temp\Book1.xls" with the path to your file, and replace "test" with your passwords.

Good luck