merging files

[Maaz]

there is a folder containing 400 excel files which are on same pattern. I
want to merge all files in a single new excel file.

 

[Ron de Bruin]

Hi Maaz

See
http://www.rondebruin.nl/copy3.htm

Or one of the other examples on my site

 

[Maaz]

i am new user i didnt know about amcros would please tell me about macros
from start

 

[Ron de Bruin]

Start here

See David McRitchie's site if you just started with VBA
http://www.mvps.org/dmcritchie/excel/getstarted.htm

And post back if you need more help