I have an extensive macro that processes raw .dat files into finished excel sheets - it imports, formats, calculates, graphs and more. The problem now is that I have a huge number of new files that I need to process, so I want to try and further automate the process. Is there a way to add a loop to the macro so that it sequentially goes through a folder and runs on each successive .dat file? My searches so far have found solutions where the batch processing is done all at the same time, due to file sizes and computing power, I would need to do this sequentially.
Thanks in advance for any tips and guidance!