I believe that with the second approach you're having two different processes (VB6 IDE and Excel) and your trying to pass a reference of an object between them.



So the problem is the way you...