I am getting txt output from fortran that i want to use in excel for some analysis.

then i use another file to reshape the data into another format and compare it for analysis using some standard data i already have
I ve done the process a few times
The import and reshape process happens to those using VBA into Sheet1 spreadsheet of "Sample.xlsm" and copy them into the "BRING" spreadsheet of "Sample.xlsm"
I want to Save As the xlsm with the current textfile name i got the import from
And in the long run to make this process iterative for every txt file in a given folder

I made a sad little macro using my very little skills and macro recording in VBA that imports the data into sheet1 but i had to manually save after each iteration
I m very unhappy as i m going to use the trial and error method to decide what the optimal values are going to be for my method, therefore i will be importing many sets of data.

I m really looking for some help though since we are talking about over 100 text files , thank you very much in advance guys