Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting Data from CSV files
Hi is it possible for excel to extract data from different csv file without opening them (something like the data import function in exce where data is extracted from the csv file but without opening it) an combining the data into an excel worksheet? for eg, i have 3 csv files, a, b & c. I want to extract column b (a when opened in excel) of csv a, column c of csv b and column d of cs c. These 3 columns of data should be then extracted into a specifie workbook(where the macro is) and worksheet and column... say worksheet and column A. in addition, the macro should take the specified filelocation, path an filename from 3 cells in the workbook... currently, i am using the excel function to import the data which i working fine but troublesome because i have to change the filenam manually and many times... which is becoming a chore especially whe there's alot of data to extract... will really appreciate any advice/suggestions... cheer -- hc ----------------------------------------------------------------------- hce's Profile: http://www.excelforum.com/member.php...nfo&userid=351 View this thread: http://www.excelforum.com/showthread.php?threadid=26346 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting data from large text files for beginner | Excel Worksheet Functions | |||
Extracting excel worksheet data to separate files | Excel Discussion (Misc queries) | |||
Extracting Data for .Txt Files By Unique Field Data | Excel Discussion (Misc queries) | |||
Extracting data from multiple excel files. | Excel Discussion (Misc queries) | |||
Extracting cell data from numerous files in multiple folders???? | Excel Worksheet Functions |