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.
Bookmarks