After it is working, i happily saved the project and put it aside.
while later, i came back to the project and do another round of testin
before submitting it to my supervisor and guess what. IT IS NOT WORKING
The same old problem persist.

That was before i saw your post Jamie. The link that you provided hit
the bullseye. The program work straightaway. Thanx a bunch for pointin
that out Jamie.

Nick: Are you recommending me to use the early binding and try to stee
away from the late binding as much as possible

--
marsulei
-----------------------------------------------------------------------
marsulein's Profile: http://www.excelforum.com/member.php...fo&userid=1606
View this thread: http://www.excelforum.com/showthread.php?threadid=27520