Ron,

Thanks for your quick response.

The password is not the same. It is different for each workbook.

I already have a macro written that will open each workbook using this line
for each workbook
Workbooks.Open Filename:="C:TestData1.xls", Password:="test1"
Workbooks.Open Filename:="C:TestData2.xls", Password:="test2"
and so on

Essentially I have the file path hard coded with the password. I prefer
your method of opening the workbooks, but not sure how to incorporate each
individual password into the open workbook command when the macro cycles
through.

Just so you know, I am a novice writing macros.

If you need more information, let me know.

Thanks in advance.

"Ron de Bruin" wrote:

Hi ScottMSP

You must create a list with file names and passwords and loop through that list.
Or is the password the same for all files ?

In the Workbooks.Open code you can add your password then
Bed time here now but if you give me the details I will help you tomorrow after work




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ScottMSP" wrote in message ...
Hello,

I am hoping someone has run into a similar situation I am having.

I am using Ron's macro that merge's seperate worksheets into one file. I
was able to tweak the macro to satisfy my needs with one exception.

Each workbook is password protected with a unique password for each. What I
need to be able to do is when the RDB_Merge macro opens each workbook, I need
the unique password to be used so that the workbook opens, then I need the
macro to finish.

Thanks in advance.