kumar23251
04-09-2012, 01:00 AM
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 realy helps me alot ...! reduces my work
Thanks
kumar
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 realy helps me alot ...! reduces my work
Thanks
kumar