Excel Macro to Merge Multiple Files (Excel, CSV, & TXT files)

[absaya2]

Hi All,

Here's a simple Excel Macro tool to merge multiple files into one. File Formats supported are MS Excel (2003 or 2007 formats), CSV, and TXT.


How to:

• Open the file. From the top menu (or ribbon) you can find the "Merge_File" menu. You should be using at least Excel 2007 version to see this menu.
• Click the "Merge Files" button and follow instructions.

I hope you find this file useful as I did.

[rapdoc]

Hi absaya2,

How I can use this marco with excel 2003 THX for your response ?

THX!!

[absaya2]

Hi RapDoc,

Try this one. I was not able to verify because I do not have Excel 2003. Hope it works.

To use, just press ALT+F8 to see the command and then press RUN.


Good Luck.

[maahsan]

You can also merge .csv file from the command line.
Click Start -> Run -> cmd

for example you have two files cell_bh_01 & cell_bh_02 and you have to merge them. You need to type these commands.

c:\>cd "Folder" //name of your folder
c:\>copy cell_bh*.csv merge.csv