merge excel files

Hello,

I found macro code online to merge .xls files. I have limited VB knowledge but was able to tweak the code to the way I want it to work for merging generic worksheets.

However, I would like another version of this macro to only merge a specific folder from each workbook... and I can't seem to get it right. Currently the code merges ALL worksheets in ALL workbooks, but I only want this new version to look at only worksheets called "Form" in ALL workbooks (even if there are 4 worksheets in the workbook, I only want to merge the "Form" worksheets).

I am attaching the code.

Could someone please help me with this. Thanks, Mary-Lou.

You can try to change your macro so:

Please Login or Register  to view this content.

Regards,
Antonio

Excellent!!!! This works great.

Thank you so much, Mary-Lou