The scientists at the above example still had to load each file individually until they enrolled in MS Excel courses that demonstrated macro editing. With this knowledge, they enlarged the functionality so the macro would import every batch of tens of thousands of data files .