Niek,

I am sorry, I could not make out how should the excel be saved. I don have a problem in creating the Macro again but I do not understand coding. So I do not use the VB script. I ll prefer redoing it. Please let me know how do I save it when creating Macro.

Thanks for your response.

Pravi.