Syntax for late binding to MSFORMS.DataObject

[Legacy 98055]

I cannot figure out the syntax for the life of me.

This should work...

Dim DatObj as Object
Set DatObj = CreateObject("MSFORMS.DataObject")

...but it does not.

Also, if it is not possible to late bind to this class, could you please explain why?

Thanks!

 

[taurean]

I hope necroposting is not bad in this case.

While I was searching for MSForms.DataObject, I found this discussion [Courtesy:=ThisThread]. So I was just checking the other links that google had thrown up.

This works [akihitoyamashiro]:

Dim oD As Object
Set oD = CreateObject("New:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}")

The big string in curly braces looks like one of those values we see in Registry. I just checked Registry and found that such strings are found against ENU_GUID. But the rest just eludes me.

 

[pgc01]

Hi Shrivallabha

It was a good idea to update this thread. Someone would read this post and might think it was not possible to create the DataObject directly (in this case led by me).

This was also posted several times here in this board, for ex. in post 3 in this thread by Rory:

http://www.mrexcel.com/forum/showthread.php?t=353731#3

In this case the object is created using the CLSID directly.

 

[taurean]

Thank you pgc01.

You always have something good to share. So the big string wrapped in curly brace is called CLSID.

 

[pgc01]

So the big string wrapped in curly brace is called CLSID.

Yes, it's thee CLaSs IDentifier of the component. You can look it up in your windows registry.

 

[CHatmaker]

See Also: http://desmondoshiwambo.wordpress.c...-tofrom-clipboard-using-vba-microsoft-access/