| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open file, Copy a column and paste this into a new Excel doc - Pl
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/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Copy, Paste not working properly, corrupts file | Excel Discussion (Misc queries) | |||
| Why won't the copy/paste from PDF retain the row/column in excel? | Excel Discussion (Misc queries) | |||
| Copy column in Excel and paste horizontally in Word. | Excel Discussion (Misc queries) | |||
| Any way to copy file names in windows explorer & paste into Excel? | Excel Discussion (Misc queries) | |||
| Copy and paste special - values into new excel file | Excel Discussion (Misc queries) | |||
![Harish Mohanbabu[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
