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