Skip navigation

Log In

Forgot your password?
Don’t have an account? Sign Up

Sign Up

Access our rich network of apps, trials, and services.

Start the registration process by entering your email address below.

Already have an account? Log In

Excel Macro: Merge All Your Excel Files In To One

Free download

Posted by: Viru

A very handy Excel Macro that allows you to merge data of all your excel files from the selected folders in to one.


Excel files are one of the biggest sources of data. It is a lot easier to process your data from Excel files from one file instead of using multiple sources.

The Excel file given here contains VBA code that lets you merge data from multiple Excel files into one with the following caveats.


  • All your Excel files should be in same folder.
  • The Excel files being process should not be open physically or in memory. In such a case you will receive a run-time error.



  • To be able to use this VBA Code, Ensure that you have enabled Macros in your Excel Workbook. Check Excel Trust Center settings for more details.
  • You can edit the code to meet your requirement. To edit the code, open the downloaded workbook and press ALT+F11 on your keyboard.


You can download this listing as part of the PowerCenter : Useful Script files bundle.


  • PowerCenter version 9.1 and 9.5
  • Microsoft Office Version: 2010


Comments Comments (28)