Extracting Data from CSV files

[hce]

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

 

[Tom Ogilvy]

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).