i am G. N. Rao using the forum 1st time. i want a macro to open the all .csv file in a folder one by one and paste few colums (say a,b,c colum) in excel sheet. in excel, first copy the file name of.csv, and paste it in 1st cell(A1) of and then paste data in abc colum in down of it and similary data copied from 2nd csv should paste in DEF colums. the .csv file names should like as below
ASD260820131200
ASD260820131500
ASD270820131200
ASD280820131200
Bookmarks