Password in opening files

[okcheung]

Hi all
How do I write a Subroutine to check
if the file needs a password to open, then I supply the password (inside the Sub when the file when opening) to open,
and in case no password needed, just open the file

 

[PaddyD]

Hi,

Do you know what the password is, in those cases where it will be required?

If you do, we can continue, if not, I refer you to:

http://www.mrexcel.com/board2/viewtopic.php?t=198756

 

[okcheung]

Hi,
Yes, I got the password on hand.

 

[PaddyD]

as a start:

Workbooks.Open Filename:="C:\name.xls", Password:="My_Password"


...what else is the code doing?

 

[okcheung]

Hi,
I want a code to check if the file is has password protected for opening, and if yes, then
Workbooks.Open Filename:="C:\name.xls", Password:="My_Password"
else
Workbooks.Open Filename:="C:\name.xls"

is there anything similar??