PDA

View Full Version : [SOLVED] Excel Password to modify in Macro...



Mr Mike
08-02-2005, 01:25 PM
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
08-02-2005, 01:53 PM
WriteResPassword:="testing"

Use that Argument in the Workbooks.Open statement.

Mr Mike
08-02-2005, 01:57 PM
Thanks for your help! :thumb