Hello,
I have multiple files in a folder.
The files are named:
File1.xls
File2.xls
File3.xls
….and so on; the number of files varies.
I am trying to write a macro, to combine all *.xls files in one workbook having each file as a separate worksheet.
Please advise.
Thank you
Bookmarks