Getting Data From EXCEl Inside OLE Container

[Elad]

Hi everyone,

I've put an O.L.E. container with a new excel sheet object inside it. I want my user to write in it some data, and then I want to access that data from my VB program. How do I do that?
Is creating the Container with excel object inside it enough, or do I have to create some other object or do anything else in order to acess information on the sheet? Please help.

Thanks, Elad

[Keger]

Hope this works for you

frmdata.OLE1.DoVerb (-1)           'Activate OLE for editing
frmdata.OLE1.Action = 7            'Make sure OLE is most current
Set objSheet = frmdata.OLE1.object.ActiveSheet     'Create and object for editing