Open Password/Read-only Spreadsheet

[jennuhw]

What is the correct code to open a password protected/read-only spreadsheet? This is what I currently have:
Set oWrkBook = oExcel.Workbooks.Open (FileLoc, password:="purple", IgnoreReadOnlyRecommended) Thanks!

 

[jonscott8]

I presume you have oExcel and FileLoc properly defined and initialized.

Set oWrkBook = oExcel.Workbooks.Open(FileLoc,,True,,"purple&quot Jon Hawkins

 

[jennuhw]

I have tried this exactly as you have told me. I have even tried changing the True to False. What is the whole syntax for Workbooks.Open()? Thanks.

 

[jennuhw]

It keeps telling me when I put the line of code the way that you say is that the file already exists when it is trying to save it.

 

[jonscott8]

http://msdn.microsoft.com/library/en-us/off2000/html/xlmthOpen.asp

Jon Hawkins

 

[jennuhw]

This is what I ended up doing.
Set oWrkBook = oExcel.Workbooks.Open (FileLoc, 3, , , "purple" ,"purple",True)
Thanks for your help!!