Macro that copies data from different excel files placed in a folder to a single excel fil

Hello to All,

Thanks in advance i am new to Macros it would be really helpful if some one will help me here.
I have a macro code which copies the data from multiple excel files in a folder and copies it to a single excel file it works fine.But now the problem is some of those excel files have hidden column for example column A and B are hidden and these files are password protected can any one help me modify my macro to solve the problem of coping
All these excel files with hidden columns
And un protecting them from the password.
Here is my code please feel free to modify this.

Please Login or Register  to view this content.

Above code works fine when excel sheets do not have password protection with hidden columns.

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.