![]() By default the option to merge all files in the folder is selected but you can also use the option to filter on the file names or to select the files you want to merge. But you can also only merge files with a specific extension in the folder. If you use the first option "XL?" it will merge all type of Excel files (xls, xlsx, xlsm, xlsb). In the section “Which Files” select the type of files in the dropdown that you want to merge. ![]() You can also set the level of subfolders in the dropdown (max of 9) ![]() After you do that you see the path returned in the UserForm. In the folder location section click on the Browse button and select the folder with the files you want to merge.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |