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



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Maaz" wrote in message ...
i am new user i didnt know about amcros would please tell me about macros
from start

"Ron de Bruin" wrote:

Hi Maaz

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

Or one of the other examples on my site


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Maaz" wrote in message ...
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.