Thanks for the help..

but recording wont solve my purpose..

actually the scenario is that where in a folder I have multiple csv   files
say text1.csv ,
text 2.csv etc & corresponding  excel  templates say text1.xls , text 2.xls
..

now i want to write a macro which opens a text1.csv and import  its content to
text2.xls in the first tab  and like wise for other files..

Not sure how to proceed if u cansuggest something would be great.