Extract data from a multiple password protected workbooks

[DarkoDeign2]

Hi,

I searched the forum on this topic and found a code for extracting data from multiple workbooks, but the password has to be the same.
Is there a solution if you want to extract data from 2 different sources that has different passwords?

 

[Herakles]

Hi,

I searched the forum on this topic and found a code for extracting data from multiple workbooks, but the password has to be the same.
Is there a solution if you want to extract data from 2 different sources that has different passwords?

Do you have a list of the workbooks and passwords?