Excel Password to modify in Macro...

[Mr Mike]

Hello

The following works on files that require a password to open, but not on files that require a password to modify.

Workbooks.Open Filename:= _
        "C:\Documents and Settings\408460\Desktop\Testing Doc.xls" _
        , Password:="testing"
End Sub

Can anyone correct my syntax so that I can open a file with a password to modify? Thanks for your help!

[Jacob Hilderbrand]

WriteResPassword:="testing"

Use that Argument in the Workbooks.Open statement.

[Mr Mike]

Thanks for your help!