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

 

[sasukeshane]

see link http://imageshack.us/photo/my-images/339/excelc.png/

 

[andrewkard]

Are you shure that password is correct?

 

[sasukeshane]

yes i type in 123

 

[EasyPro Dude]

Where is workbook located on computer?

 

[sasukeshane]

on my desktop

 

[EasyPro Dude]

That's the problem. Move protected workbook to local disk ,or edit path in code.

 

[sasukeshane]

i already edited the path but still not working

 

[EasyPro Dude]

Try restoring code to previous state and move workbook to local disk.

 

[sasukeshane]

not working still xc

 

[sasukeshane]

any other code that I should try ??