Macro to open password protected workbook..

[Andy D 2002]

hi
what code do i need to get a macro to open a password protected workbook if password to open is say "123"?
thanks
Andy

 

[EasyPro Dude]

Are you using Windows XP?

 

[EasyPro Dude]

If you are using XP, try this:

Sub open_Workbook()
Workbooks.open Filename:= _
"C:\documents and settings\user\desktop\Hello.xls", _
Password:="123"

Where user in the path is your username. Make sure
you type in correct file extension for excel file.

Works like a charm here.
Just remember you need to protect workbook again before you
Close it.