Hi , Thank you for a quick reply on this. Yes this solution will work for sure. But since I am trying to automate the process i didnt want the user to open every excel file and manually change the type. It is not actually practical as there several of such excel files. Any thoughts ? Thanks a lot for helping. Regards, Liju.
... View more