Open password protected workbook.

[Tom]

Hello,

I set password for open workbook (only for write). Now I'm trying open this
workbook with macro run in another workbook. I thought its possible like
this:

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

but it dosnt work. Can you help me?

Thanks in advance for your help

TOM

 

[Guest]

There is a Password parameter and a WriteResPassword parameter. Should not the password string be within double quotes?

 

[Tom]

Thanks this is good:

Workbooks.Open Filename:="C:\tom.xls", WriteResPassword :="tom"

TOM

There is a Password parameter and a WriteResPassword parameter. Should

not the password string be within double quotes?

 

[pcc]

If you only need data from a protected workbook, I have
used this:
Workbooks.Open Filename:="C:\tom.xls", ReadOnly:=True