Dear Richard,

Thank you for your feedback. i gooogled it up and came accross "Late" and "Early" binding concepts. Apparently i was using early binding.I have made the adjustments and the code is working OK. Any student who wants to read more about this can check the following articles:
http://www.dicks-clicks.com/excel/olBinding.htm
Is about Excel VBA but gives the general overview between early and late binding

http://www.databasejournal.com/article.php/1464721
Illustrates the creating a task with Late binding.

I found these two articles invaluable in generating my code. I can share the later if anyone is interested.

Best regards,

MICAH