Password
 

Hi.
I want to create a worksheet that access data from password protected
worksheet without entering
a password, such as a command that has the password to open.

Password
 

Hi George,

I want to create a worksheet that access data from
password protected
worksheet without entering
a password, such as a command that has the password to
open.

This should do:

Workbooks.Open FileName:="abcd.xls", password:="abcd"

Best

Markus




.