将csv转换为xls时宏的问题

I am getting a problem on my project.There is one xls file with a macro that create a chart and the cell type of that xls file is 'text'.I have to make multiple duplicate copies of that file with the macro and then from a folder named 'result' i have to fetch the csv files and put the values to those duplicate xls files one by one and through macro I have to create charts corrosponding to those values.I know how to get values from csv and put it to one xls file.I also know the codes of the macro that can create a chart.I am getting a problem on my project.There is o