Hi Unanimous,
Thanks a lot for the new method. It works great. I should say the data transfer speed is more than 10x. It saved my work.
Thanks to others for suggestions on WriteExcel. I kept away from it as i've heard that existing excel files cannot be worked on with that module.
Joseph.