View Full Version : Needed help on copying the data from .csv file to another excel sheet

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


04-10-2012, 10:53 PM
Any one can help on this please .. !!

: pray2: