Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import multiply csv files
Hi,
Using Excel 2000, I have a weekly task to open 35 CSV files and to merge the contents which is about 1000 rows in each into a single file. Each file has a unique name and is in a specific directory. What I'd like to do is have some code that would allow a dialog box to appear, select the directory and for all the csv files in that directory to be merged into one file. I've searched the web but can't find any code to get me started, any ideas? Thanks, Rob |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import multiply csv files
Hi Rob
Lots of code to do this type of thing at Ron de Bruin's site http://www.rondebruin.nl/copy3.htm -- Regards Roger Govier "Rob" wrote in message ... Hi, Using Excel 2000, I have a weekly task to open 35 CSV files and to merge the contents which is about 1000 rows in each into a single file. Each file has a unique name and is in a specific directory. What I'd like to do is have some code that would allow a dialog box to appear, select the directory and for all the csv files in that directory to be merged into one file. I've searched the web but can't find any code to get me started, any ideas? Thanks, Rob |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import multiply csv files
Thanks Roger, plenty to get on with here.
"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Rob Lots of code to do this type of thing at Ron de Bruin's site http://www.rondebruin.nl/copy3.htm -- Regards Roger Govier "Rob" wrote in message ... Hi, Using Excel 2000, I have a weekly task to open 35 CSV files and to merge the contents which is about 1000 rows in each into a single file. Each file has a unique name and is in a specific directory. What I'd like to do is have some code that would allow a dialog box to appear, select the directory and for all the csv files in that directory to be merged into one file. I've searched the web but can't find any code to get me started, any ideas? Thanks, Rob |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import multiply csv files
Does the order the files are combined in matter? If so (and I would guess it
is so), is there something in the names of the files (such as a sequence number or date) which can be used to determine the order they are to be combined in? Also, do you have a preference for the name of the file that the combined data is saved under? Rick "Rob" wrote in message ... Hi, Using Excel 2000, I have a weekly task to open 35 CSV files and to merge the contents which is about 1000 rows in each into a single file. Each file has a unique name and is in a specific directory. What I'd like to do is have some code that would allow a dialog box to appear, select the directory and for all the csv files in that directory to be merged into one file. I've searched the web but can't find any code to get me started, any ideas? Thanks, Rob |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import multiply csv files
Hi Rob
See also http://www.rondebruin.nl/csv.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rob" wrote in message ... Thanks Roger, plenty to get on with here. "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Rob Lots of code to do this type of thing at Ron de Bruin's site http://www.rondebruin.nl/copy3.htm -- Regards Roger Govier "Rob" wrote in message ... Hi, Using Excel 2000, I have a weekly task to open 35 CSV files and to merge the contents which is about 1000 rows in each into a single file. Each file has a unique name and is in a specific directory. What I'd like to do is have some code that would allow a dialog box to appear, select the directory and for all the csv files in that directory to be merged into one file. I've searched the web but can't find any code to get me started, any ideas? Thanks, Rob |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import multiply csv files
The files contain dates and as such I can sort once in a single worksheet,
the examples that Ron has on his website will I think solve my problem. I'll post back once I've had a chance to run Ron's examples. Thanks to all for the help. "Rick Rothstein (MVP - VB)" wrote in message ... Does the order the files are combined in matter? If so (and I would guess it is so), is there something in the names of the files (such as a sequence number or date) which can be used to determine the order they are to be combined in? Also, do you have a preference for the name of the file that the combined data is saved under? Rick "Rob" wrote in message ... Hi, Using Excel 2000, I have a weekly task to open 35 CSV files and to merge the contents which is about 1000 rows in each into a single file. Each file has a unique name and is in a specific directory. What I'd like to do is have some code that would allow a dialog box to appear, select the directory and for all the csv files in that directory to be merged into one file. I've searched the web but can't find any code to get me started, any ideas? Thanks, Rob |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import multiply csv files
Thanks Ron, I'll have a play this weekend and post back my success!
Regards, Rob "Ron de Bruin" wrote in message ... Hi Rob See also http://www.rondebruin.nl/csv.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rob" wrote in message ... Thanks Roger, plenty to get on with here. "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Rob Lots of code to do this type of thing at Ron de Bruin's site http://www.rondebruin.nl/copy3.htm -- Regards Roger Govier "Rob" wrote in message ... Hi, Using Excel 2000, I have a weekly task to open 35 CSV files and to merge the contents which is about 1000 rows in each into a single file. Each file has a unique name and is in a specific directory. What I'd like to do is have some code that would allow a dialog box to appear, select the directory and for all the csv files in that directory to be merged into one file. I've searched the web but can't find any code to get me started, any ideas? Thanks, Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Several .txt Files | Excel Discussion (Misc queries) | |||
add value of 4 cells, multiply by 3 subtract 72 multiply by 80% | Excel Discussion (Misc queries) | |||
Import files on a mac | Excel Programming | |||
import files | Excel Programming | |||
Import multiple files macro can't find files | Excel Programming |