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!
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!