This is code snippet is able to load a bunch of xls-files with the same data format but with different file-names, even perhaps with different sheet-names and located in a folder with subfolder(s).
It´s based on this thread from the archive. Thanks to the anonymous user. [;)]
SUB DoDir (Root) FOR each File in filelist(Root& '\*.xls') LOAD value1, value2, value3 FROM [$(File)] (biff, embedded labels); //by leaving the part of naming the table it uses all tables of the file NEXT File FOR each Dir in dirlist (Root&'\*') CALL DoDir(Dir) NEXT Dir END SUB CALL DoDir('c:\test')
By modifying the code you will be able to load mutiple files in other file formats like csv and so on.