Supply password to open in read/write mode

gruple

New Member
Joined
Dec 5, 2005
Messages
8
I have several spreadsheets that open in read only and ask for a password if you want to open them in read/write mode. I have tried searching for the answer, but I didn't find exactly what I am looking for. I am missing something in the syntax. I have the macro to open the file and update the links but when I try to add the password to open, I get an error message. Thanks for the help.
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Watch MrExcel Video

Forum statistics

Threads
1,113,859
Messages
5,544,710
Members
410,631
Latest member
JFORTH97
Top