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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting Data from CSV files
If you record the operation of importing the files, you should be able to
modify the code to do what you want. You can make the filename a variable, then get that value from your cells. You can import the whole files and delete the columns you don't want or you might be able only import the single column (I haven't explored that). -- Regards, Tom Ogilvy "hce" wrote in message ... Hi is it possible for excel to extract data from different csv files without opening them (something like the data import function in excel where data is extracted from the csv file but without opening it) and combining the data into an excel worksheet? for eg, i have 3 csv files, a, b & c. I want to extract column b (as when opened in excel) of csv a, column c of csv b and column d of csv c. These 3 columns of data should be then extracted into a specified workbook(where the macro is) and worksheet and column... say worksheet1 and column A. in addition, the macro should take the specified filelocation, path and filename from 3 cells in the workbook... currently, i am using the excel function to import the data which is working fine but troublesome because i have to change the filename manually and many times... which is becoming a chore especially when there's alot of data to extract... will really appreciate any advice/suggestions... cheers -- hce ------------------------------------------------------------------------ hce's Profile: http://www.excelforum.com/member.php...fo&userid=3518 View this thread: http://www.excelforum.com/showthread...hreadid=263469 |
Reply |
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 |