Hi,

I want to import a CSV file to an Excel file automatically. The CSV file is located on 'D:\MyData' and the filename called 'Data1.CSV'.

The Excel filename is 'E-Data1.xls'. After open the Excel file it should erase previous imported data and import the data from the latest CSV file, then it should auto save and close the Excel file.

The imported data is save under the Excel worksheet called 'row_data'


The Flow should be like this.

1) Delete previous imported data(data from previous CSV file)
2) Import data from CSV file to Excel worksheet 'row_data'.
3) Auto save the excel file 'E-Data1.xls'.
4) Close the Excel file.

Appreciate if you can help me.

Thanks
Kee