Needed help on copying the data from .csv file to another excel sheet .. It's urgent

[kumar23251]

Hi All,

My requirement :

1) I have attached 2 sample sheets [ book1.csv & bokk2.xls ] .I want to copy the data from book1.csv to book2.xls with single click .while copying it should copy the whole data [ 4 columns ] to book2's first 4 colums .and should save it as the same file name [ as book1.xls ]

Like this i have plenty of .csv files to be converted into predefined .xls sheet .

So could you please help me to do this using a macro


with single click it should copy all the .csv files which are present in a folder to another predefined .xls sheet and should save the files as same name with .xls xtension


Hope you guys can help me on this ..

Thanks in advance this will really helps me a lot ...! reduces my work

Thanks
kumar