Excel, WordPad and DDE
 

Hi guys.

I need to embed WordPad document inside Excel using VBA.

Dim text as string
text = "test"

Dim o As Object

Set o = ActieSheet.OLEObjects.Add(ClassType:="Wordpad.Docu ment.1",
Link:=False, DisplayAsIcon:=False)


And now, my question is how to store something in "o" and how to read
text from WordPad object.
Does anyone know?