I try to use Excel to deal with some calculation.
I need to open one txt file, input the data into Excel spreadsheet, FFT, save result, close the txt file; then open the second txt file, repeat the process, then the third.....
All the txt files have sequential file name, say MAN001, MAN002, .....MAN270.
I don't know how to integrate the LOOP process with the open command to open those series of files and close them automatically. Say I want to analyze 5 files from MAN130.

Please Help!!!!!!!