Thanks Ron de Bruin,

that is working fine.

Can u please help me for following issue:-

As I mentioned before that I have around 50 files in folder and I want to
run excel macro on all files in folder and save them.

Kindly help me plz.

Thanks

"Ron de Bruin" wrote:

See also
http://www.rondebruin.nl/summary2.htm

Or
http://www.rondebruin.nl/merge.htm

--

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


"TFMR" wrote in message ...
Hi All,

I have 50 excel files in folder I want to copy e1,f1,g1,h1,i1 to one new
file against file name. In new excel file in a column files name until 50 and
e1 the first file's data, e2 to i2 2nd files data and so on till 50 files.

Thanks