Hi Rohan.

Ron de Bruin has an extensive range of sample code at:

Ron's Excel Tips
http://www.rondebruin.nl/tips.htm

See, for example:

Merge data from all workbooks in a folder(Dir)
http://www.rondebruin.nl/copy3.htm

and

Merge data from all workbooks in a folder(FSO)
http://www.rondebruin.nl/fso.htm


---
Regards,
Norman


"Rohan" wrote in message
...
Hi ,

I am a set of excel files in a folder . I want to open every excel file in
the folder and then open another excel workbook with some formats and
paste
the contents to the template , the script then needs to save this in
another
folder and then quit. Any help in this would be great..
--
Rohan Patnaik