How to display the names of all the workbooks within a folder

[vibhutiverma]

I have written a code to merge sheets in a workbook. But now I want it to run through all the .xlsx files with a specified folder.
But the below-mentioned code doesn't seem to be working.

Please Login or Register  to view this content.

Error - Subscript out of range error
Please let me know if you have a solution to it or an alternative approach to run code through multiple files in a folder without opening.
Thank You.

[davesexcel]

Workbooks(FileName).Activate

You can't activate a closed workbook.

[vibhutiverma]

Thanks.

Could you let me know how to refer to that workbook?

[davesexcel]

I do have a code and a youtube clip on how to use the code.

Please Login or Register  to view this content.

See my clip on how to use it.
Loop Through a folder of workbooks

[vibhutiverma]

Thank You. This works.