Open file, copy field and paste into an Excel doc! - Pl help ..

Hi,

There are around 700 files in a particular directory. This directory is mapped to my drive (F:\)

What I want to do is -

1) Open the files one by one in the above directory
2) Copy just a particular column (B3) alone in all those files
3) And paste them all into a different Excel file

These files are in XML format, but could be opened with Excel.

Can someone help me please.

Thanks,

Harish Mohanbabu