VBA - Opening password protected workbook?

[Rags]

Hi

I need to open a password protected workbook using VBA.

I've tried the code below but I still get prompted for a password.

Workbooks.Open Filename:="\\HOME\Working\Report.xls" _
        , Password:="xxxx"

How do I get it to open automatically???

 

[Richard Schollar]

Hi

That should work for a workbook that's password protected to open, is it possibly password protected for writing instead (or as well as)?

 

[gingersteve]

Is there also a Write-Reserved Password on the file? i.e. does it ask you whether you want to open it as read only? If so, you also need to include WriteResPassword:="xxxx"

 

[Rags]

Ok, thanks, I just worked that out myself too.