I received so many unpublished question regarding merging multiple excel files with macros, some of them ask about things that i don’t understand. Please understand that I’m not an expert on this Excel Marcos stuff since i also got the trick from friend. But i’ll do my best to find the answer and reply to all unpublished questions/comments.
Anyway i decided to share our tiny Excel merger tool that we created several month ago and we used to use it to merge small excel files on our daily office work — we called it Oa Excel Merger. Well, this is not a perfect tool because it can only do a simple merging task, can only merge first sheet of every excel files and copy them all into a new file (similar to whats macros code did on my previous post).
Oa Excel Merger require MS Office Excel installed on your system (MS Office 2007 Recommended). All merging process are done thought MS Excel. Which mean MS Excel did all the merging, this tool act only as a simple excel file manager. You can either hide or show the MS Excel Window during merging process by enabling this feature on options menu.
While this is not a great excel merger tool, we hope it can be useful to anyone. Now it’s your choice to choose between pasting macros code into Excel macros editor or just dragging Excel files into our simple merger tool. Both of them work well for us –have a nice day and have fun.
There is a new tool to merge spreadsheets documents named Oa Spreadsheets Merger (OSM), doesn’t require Ms Excel and support xls, xlsx, ods (open spreadsheet documents) and csv.