Unbound OLE object

[Stan Schnuerer]

Using the Action acOLECreateEmbed property with an Excel worksheet to an Unbound OLE object on a Form. VB executes fine (.class, .OLETypeAllowed, .SourceDoc statements working without errors). Then it halts at the OLE1.Action acOLECreateEmbed statement

Run-time error 2793... can't perform the operation specified in the Action property..

I hit debug and hover the cursor over the Action statement and read
"OLE1.Action = ...can't retrieve the value of this...

I have played around with what seems intuitive on the Property sheet, but couldn't get any further

 

[Stan Schnuerer]

No worries now. I examined the code a little closer and found I had missed the "ac" in "acOLEEmbedded". Also, the Action property was only recognized after I wrote "me.OLE1.Action"; I needed to have the "me." in front

Things are looking much better now.