I am looking for a macro that can extract data from multiple .out files and compile into one master Excel worksheet. I recorded a macro of myself doing an import of one .out file which is below.
In doing this, the number of rows is always different but the last populated column is always 'DM'. The folder containing my .out files contains all the out files I need imported and none that I don't. It doesn't matter what order they are brought in to Excel either as long as all are imported once.
Importing one text file is easy enough, but then I must scroll to the bottom and from there manually import the next file. If the macro I recorded was able to go to the next file without prompting that would be ideal.
Here is the macro of one import- starting with Get Data From text ending with pasting to a location in spreadsheet.
Any help would be greatly appreciated!
Bookmarks