Need a macro to copy paste data from multiple files into a file as a database

Do you want them pasted side by side - one under the other????

Try this: (it's called "running the directory")

Please Login or Register  to view this content.

Unfortunately it doesnt work. I`m new to the world of Macro so I couldnt understand what is the problem.

Let me explain my need in detail. In a folder, I have many reports (excel files) named; 201201 Report.xlsx, 201202 Report.xlsx, 201203 Report.xlsx, 201204 Report.xlsx... These workbooks have many sheets.

I need copy data from these workbooks` "A1:D500" cells in "Direct Pers" sheet and paste as a database into a new workbook (pasted one under the other).

Thanks in advance.

Hi etandogan,

The program works for me on my system - I know that the backslash at the end of the path is critical -if your configuration includes the backslash in the path then it shouldn't be appended. One way to discover whether the configuration is copacetic to my code is to single step through the program (by hitting F8), and see whether the:

Please Login or Register  to view this content.

yields a result rather than a null "".

You can change the names and range particulars as well as the

Please Login or Register  to view this content.

to conform to your actual situation.

And, one other thing - do you realize that the program must be in a macro-enabled Workbook (extension - .xlsm)

Hi etandogan, try this (new code in red)

Please Login or Register  to view this content.

And - You're welcome!

Well then - maybe:

Please Login or Register  to view this content.

Hi etandogan,

Here's a change that should work - that I should have thought of sooner - just change the open statement:

Please Login or Register  to view this content.

You're welcome again - it always seems so easy once it's done!