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

marsulein,
Depends on your situation, but there is certainly no reason to use both for
the same class.
Early is easier, as you get Intellisense and faster.

NickHK

"marsulein" wrote in message
...

After it is working, i happily saved the project and put it aside. A
while later, i came back to the project and do another round of testing
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 hits
the bullseye. The program work straightaway. Thanx a bunch for pointing
that out Jamie.

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


--
marsulein
------------------------------------------------------------------------
marsulein's Profile:
http://www.excelforum.com/member.php...o&userid=16064
View this thread: http://www.excelforum.com/showthread...hreadid=275204