Hi Dhiraj,

Could you post the code here ?

In the meantime, have a look at this http://www.excelfox.com/forum/f12/ex...d-convertor-9/

you didn't give the feedback on this Collate Data from csv files to excel sheet