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