Macro to auto update links to password protected workbooks

I am new to VBA.

I have a master workbook that pulls summary data from several workers' workbooks.

The worker's workbooks are all password protected with unique passwords.

Is there a macro that will let me update links and then enter the passwords to each of the worker's workbooks?

Record macro produced nothing but the name and description.

I tried to use some of the codefrom the last post on this thread http://www.excelforum.com/excel-prog...ugh-vba-2.html but I am getting a runtime error.

Thanks,
Mark

Welcome to the forum

This is a format that will open a file so that you can modify it

Please Login or Register  to view this content.

Are all the files in a single folder?
Are there any other files in that folder?
Where are the passwords associated with each file held?

Hi Mark,

Depending on how the workbooks are protected, here are a couple of examples.

If the workbook is password protected for opening (Password) and for modification (WriteResPassword) and you want full access rights, then this would be the code in VBA to open it. If it is only password protected for opening or only password protected for modifying and you need full access rights, then you would use whichever one is in effect.

Please Login or Register  to view this content.

If the workbook is password protected for opening and you only need readonly rights to extract data, you could use this code.

Please Login or Register  to view this content.

Based on your post, it sounds like you only need to open the workbooks to extract information, so it sounds like the 2nd option would be what you want.

Hope that helps,

Dan

This is exactly what I needed.
Its working in my test folder. I will try it on the network tomorrow. The only difference should be redefining the path.
Thanks so much. Yesterday, I bought a book on VBA so hopefully I can figure this out on my own next time.

Best,
Mark