How can I open a protected file?

Hi,

I have several excel files protected with the same password (ex: pwd) in a directory. I want to create a macro that is going to open each file and copy the inside information to a new workbook.

In VBA, how can I open a excel file protected?

Regards,
Élio

Maybe I don't understand your post completely, but look at "open method" in the VBA help file. It is straightforward. The password is simply another parameter to the VBA command.