Consolidating multiple excel files
To choose the merge option, click the arrow next to the Merge button and select the desired merge option. To merge Microsoft Excel files together, it is best to save them as CSV files first.
Open the Excel files and in the menu bar, click File, then Save As.
Type in the following command to merge all TXT files in the current directory into the file named (any name could be used).
Once completed, the text and other information from the document will be merged into the current document.
However, if there is any confidential information contained in the PDF files, use caution when merging them online.
It is recommended that you use a utility on your computer for these types of PDF file mergers, to ensure the confidential data is kept confidential.
In the Save as type drop-down list, select CSV (comma delimited) (*.csv) from the list.
Do this for each Excel file you want to merge, then place all the CSV files in the same folder.
Search for consolidating multiple excel files:
Screen Updating = False Set Merge Obj = Create Object("Scripting.