Hi all,



I have a problem importing data from csv file into excel. Through the 'open' 
command it works fine, but I want to create an excel workbook with several 
sheets and import different data from several csv-files into this workbook.
The VBA command is:  Activesheet.QueryTables.Add(Connection 
:="TEXT;c:\temp\test.csv", Destination := .Range("A1"))

I've tried a number of sytaxis, but it doesn't seem to be correct.
for example:
oSheet:Querytables.callMethod("Add","TEXT;c:\temp\test.csv", 
oSheet:Range("A1"))
oSheet:Querytables:Add(connection := "TEXT;c:\temp\test.csv", destination := 
oSheet:Range("A1"))

Can anyone help please......

greetz,
Marty