We believe the macro recorder can do this job.

Add a new worksheet;
get new filename;
name the worksheet with filename;
import the csv file;

continue with next file

Regards
"Chris Lewis" wrote in message
...
Can anyone help me. I want to convert a number of csv files (all in the
same folder) into an excel file. I would like each csv to be a worksheet
in
the excel file with the sheet name the same as the csv file name but
without
the .csv file extension.

I guess it would be easy if I was prompted for which folder I want to use
as
source as I have to do this over and over again!!

--
Chris Lewis