Open password protected workbook.
 

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

Open password protected workbook.
 

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

Open password protected workbook.
 

Thanks this is good:

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

TOM

"AA2e72E" pí¹e v diskusním pøíspìvku
...
There is a Password parameter and a WriteResPassword parameter. Should
not the password string be within double quotes?

Open password protected workbook.
 

If you only need data from a protected workbook, I have
used this:
Workbooks.Open Filename:="C:\tom.xls", ReadOnly:=True
-----Original Message-----
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


.