CreateObject(.net 2.0 COM object)

[owen79]

Firstly, apologies if this is deemed to be in the wrong group...

I'm getting the impression from other postings and general searching
that it isn't possible to create an instance of a .NET 2.0 COM object
in VBA under Office 2003.

The information I am reading is that as Office runs under the 1.1CLR,
it can't start a 2.0CLR object.

Is there anyone who can confirm or deny this for me?

Thanks very much in advance.

Owen

 

[Perry]

Have you tried to early bind and set a reference in VBE manually ??
If not, try to do so first and then start thinking about possible late
binding using CreateObject().

Let's say, you get it to work:
I doubt that you can do something with the instantiated object;
you would need a development interface supporting the properties/methods
exposed by this object.
Basically, you *can* "Implement" development interfaces in VBA, but are you
sure you want to
go down this dark, narrow and long alley?

--
Krgrds,
Perry

System:
Vista/Office Ultimate
VS2005/VSTO2005 SE