Using VBA to import csv files

Using VBA to import csv files

Hi,

Could you tell me whether it is possible to use vba code to read in csv files automatically? I would like to use zoho sheet to analyze the results of a survey - stored as several csv files. I can do this manually using the import facility but would prefer to use a macro if possible. I've tried recording my actions but this doesn't work! Other than that this is a brilliant piece of software.

Andrew Tregoning