Opening Multiple sheets and inserting password

[afelipe2001]

Well this is my very first post! I am really hoping someone has an interest in reading because I really need some help. I have about 20 files e-mail to me every day that need to be:
1. openned - half way done. I have the code to open 1 file but not the other 20, who share the same name except for a
number at the end which is progressive. "formato de inventario 1" then "formato de inventario 2" etc..
2. insert password = chicken - half way done. I get promted to introduce the password but havent been able to have VBA type "chicken".
3. unhide columns B and C - done
4. select range A6:P55 -done
5. Copy information -done
6. Paste in a "Master File" for further processing -done

I am attaching the file that will be used to "centralize" all the information as well as the files we will be copying information from. I am using Excel 2007 on a 64 bit system.

Please Login or Register  to view this content.

[afelipe2001]

I would like to ask for someones help on this topic again. Any assistance would be appreciated.

[arlu1201]

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.