VBA: How to create the Designer.Application object using CreateObject?

[Former Member]

In VBA, does anyone know how to create the Designer.Application object using CreateObject or GetObject?

Instead of the code:

Dim BOApp As Designer.Application

Set BOApp = New Designer.Application

I want to use:

Dim BOApp As Object

Set BOApp = CreateObject(u201CDesigner.Applicationu201D)

But I get an error which would imply that the class name is not correct. What is the correct class name?

Thanks in advance,

Nic.

[Former Member · Accepted solution]

Hi,

I think that you must reference the version the object class, like this:

Set BOApp = CreateObject(u201CDesigner.Application.12u201D)

Regards

Didier

[Former Member · Accepted solution]

That works, thanks very much!