Get data from protected file, changes required in existing code

Hi,

I Have 25 files saved in a folder. I have one master file where I run a macro to merge data from all those files and collate in my master file.
I use the below macro which is working perfectly for me

Please Login or Register  to view this content.

However I have a problem if those 25 files are protected. I do have list of files and their respective password to open those file. Is it possible to give the passwords and file names declared in the code so that when a macro runs it doest not ask for password.

Regards
Arvind

I have also asked the same question in the below link :
http://www.vbaexpress.com/forum/showthread.php?t=29181