Hey there. I'm not sure on how to do this.
I need to communicate with an embedded Excel object that is on my form, I mean I'd like to read from some cells and write to others, but I can't access it!
How can I refer to it on code?
Lets say my OLE obj is called OLE1, and I'd like to do something like:
OLE1.Worksheets("sheet1"
.Range("a1"="Some text"
This won't work, so I guess I need to refer to it in another way, anyone knows hoe to do this?
And btw... do you know if it's possible to save an OLE embedded Excel obj as a .xls file or it'll only be possible to save as a .ole file?
Please can someone give me a hand, I'm getting out of ideas here
I need to communicate with an embedded Excel object that is on my form, I mean I'd like to read from some cells and write to others, but I can't access it!
How can I refer to it on code?
Lets say my OLE obj is called OLE1, and I'd like to do something like:
OLE1.Worksheets("sheet1"
.Range("a1"="Some text"This won't work, so I guess I need to refer to it in another way, anyone knows hoe to do this?
And btw... do you know if it's possible to save an OLE embedded Excel obj as a .xls file or it'll only be possible to save as a .ole file?
Please can someone give me a hand, I'm getting out of ideas here
