| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Cells from CSV files in folder into one worksheet
Hi Everyone,
I need to combine cells from some CSV files that are in the same folder into one excel worksheet. I went to Ron de Bruin's page and I saw a macro that does what I want to do but does it for excel files in a folder http://www.rondebruin.nl/copy3.htm#header . I tried changing the code by replacing "**.xls" with "**.csv" but this didnt seem to work. Does anyone have any ideas? Thanks, Reece |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying Cells from CSV files in folder into one worksheet
Found the answer on the same webpage referred to in message, no need to
respond. wrote: Hi Everyone, I need to combine cells from some CSV files that are in the same folder into one excel worksheet. I went to Ron de Bruin's page and I saw a macro that does what I want to do but does it for excel files in a folder http://www.rondebruin.nl/copy3.htm#header . I tried changing the code by replacing "**.xls" with "**.csv" but this didnt seem to work. Does anyone have any ideas? Thanks, Reece |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying visible cells only on a protected worksheet | Excel Discussion (Misc queries) | |||
| Sorting and copying data to another worksheet in a workbook. | Excel Discussion (Misc queries) | |||
| Copying and Pasting a Worksheet | Setting up and Configuration of Excel | |||
| Linking cells in a worksheet to other worksheets in a workbook | Excel Discussion (Misc queries) | |||
| Cannot access read-only documents. | Excel Discussion (Misc queries) | |||
Hybrid Mode
