I have no programming background but have managed to record a macro to import a single text file into a worksheet.
The code is below but
Can someone show me how to amend this so that the macro does a loop and picks up all the text files under location W:\xyz\abc\
I did try code like below but i didnt work
Also when the save is done to the worksheet, I would like each worksheet within the spreadsheet to be called the name of the text file that has been run in? can someone please provide the code on how to do this?