| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 -- Harish Mohanbab ------------------------------------------------------------------------ Harish Mohanbab's Profile: http://www.excelforum.com/member.php...fo&userid=6332 View this thread: http://www.excelforum.com/showthread...hreadid=392859 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Copy, Paste not working properly, corrupts file | Excel Discussion (Misc queries) | |||
| Copy and paste special - values into new excel file | Excel Discussion (Misc queries) | |||
| Open file, Copy a column and paste this into a new Excel doc - Pl | Excel Programming | |||
| From excel - open word doc and copy form field contents to excel c | Excel Programming | |||
| Macro to Copy data from e-mail and paste it into a field on a website | Excel Programming | |||
Threaded Mode
