Actually, no. I cannot provide code. That’s what I am looking for.

I want to do the equivalent of

Set obj = new classname

However, the name of any actual class (e.g., classname) is not know
during programming, so the above statement cannot be hard coded. It i
only during program execution that actual class names are known.

This may not be possible except through slight of hand, which I woul
like to avoid.

Possible solutions that I might be forced to try would include:
-- using some type of immediate execution code to execute a characte
string statement or
-- writing code to a class module and then executing that code

--
ALittl
-----------------------------------------------------------------------
ALittle's Profile: http://www.excelforum.com/member.php...fo&userid=2869
View this thread: http://www.excelforum.com/showthread.php?threadid=48748