Using Excel 2016, I have 20 .xlsx files which I would like to combine into one workbook. Note that each files has only one worksheet, so it should be an easy merge (I don't care about the name of the worksheets or anything like that).
I have tried copying some VBA codes from other posts, but I am always getting some kind of error (perhaps they were for older versions of Excel, I don't know).
I am clueless about VBA, but I see I need it desperately.
I have tried copying some VBA codes from other posts, but I am always getting some kind of error (perhaps they were for older versions of Excel, I don't know).
I am clueless about VBA, but I see I need it desperately.