I have 250 CSV workbooks with the same type of data. The moment I open these files, I run "custom macro 1" to reorganize the data. How can I apply this macro to all my files in any order?
More detail: After this is done, I'm going to merge my workbooks together. I can't merge them before hand because the files are going to be too big. "Custom macro 1" would run for days.
Thanks,
Simon
More detail: After this is done, I'm going to merge my workbooks together. I can't merge them before hand because the files are going to be too big. "Custom macro 1" would run for days.
Thanks,
Simon