unlocking workbooks

[guilhaume]

Hi all
I have thousands of excel file which workbooks are protected
I know the password
somebody told me visual basic was the easiest way to unlock protecte
workbooks
I don't know VB
Can somebody provide me a vb code in order to unlock those files?

Thanks to al

 

[Dave Peterson]

What type of protection?

Tools|protection|protect worksheet
tools|protection|protect workbook

Or File|open password?

If it's the worksheet password:

I'd build a worksheet that contained the name of the workbook in column A.
the name of the worksheet in column B (multiple rows per workbook)
and the password for each worksheet in column C

If it's the file|open password, then just the filename in column A
and the password to open in column B.

Post back with more details and I'm sure someone can help out looping through
the list trying to unlock, well, whatever you have locked.