I've got a macro that opens other Excel workbooks to pull specific data that
constantly changes. These workbooks are password protected. Is there language
I can put in the macro to fill the password field? Right now when I run the
macro, I need to manually enter the password for each workbook that the macro
opens.

Thanks!
Darren

One suggestion: record a macro during which you force a password-protected
workbook to open and see what code XL puts in for such an action. Then use
that.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"DBM" wrote:

I've got a macro that opens other Excel workbooks to pull specific data that
constantly changes. These workbooks are password protected. Is there language
I can put in the macro to fill the password field? Right now when I run the
macro, I need to manually enter the password for each workbook that the macro
opens.

Thanks!
Darren

Take a look at VBA's help for workbooks.open.

Workbooks.Open Filename:="C:\my documents\excel\book1.xls", _
Password:="PWD111"



DBM wrote:

I've got a macro that opens other Excel workbooks to pull specific data that
constantly changes. These workbooks are password protected. Is there language
I can put in the macro to fill the password field? Right now when I run the
macro, I need to manually enter the password for each workbook that the macro
opens.

Thanks!
Darren

--

Dave Peterson

I couldn't get the password to work, however I was able to change the
workbooks that were protected to be read only. I could then open the
workbooks with the following string without having to manually click 'Read
Only'.

Thanks for your help!!

Workbooks.Open "C:\my documents\excel\book1.xls", , True

"Dave Peterson" wrote:

Take a look at VBA's help for workbooks.open.

Workbooks.Open Filename:="C:\my documents\excel\book1.xls", _
Password:="PWD111"



DBM wrote:

I've got a macro that opens other Excel workbooks to pull specific data that
constantly changes. These workbooks are password protected. Is there language
I can put in the macro to fill the password field? Right now when I run the
macro, I need to manually enter the password for each workbook that the macro
opens.

Thanks!
Darren

--

Dave Peterson