G
Guest
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 (B4) alone in all those files
3) And paste them all into a single Excel file
These files are in XML format, but could be opened with Excel.
Can some one help me please.
Thanks,
Harish Mohanbabu
MBS Axapta - MVP
http://www.harishm.com/
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 (B4) alone in all those files
3) And paste them all into a single Excel file
These files are in XML format, but could be opened with Excel.
Can some one help me please.
Thanks,
Harish Mohanbabu
MBS Axapta - MVP
http://www.harishm.com/