I need your help in order to create a macro that will do the following:
I have around 15 TXT files to import (comma or tab delimited) in a workbook and I would like, by a simple click on a macro button, to create a new worksheet at the end of the opened workbook then import the TXT file, The new worksheet name would be the TXT file name. It will repeat the same step (create new worksheet then import TXT file) until all .TXT files have been imported in the workbook.
The workbook and the TXT files are in the same network folder. The workbook already contains worksheets that need to manipulate the new imported data.
I am totally new to VBA Excel
Thanks for you help,