I need to display some highly formatted text on an excel document. It is also too long to fit in a cell.
I am using sheet.OLEObjects.Add to embed a Word document on a sheet. Excel seems to treat it as a Shape, and I can control only basics such as posistion and size of the object.
Manually, I can double click on the embedded object to edit it (insert text, etc). At this point, I am talking directly to Word.
How can I do this in VBA??? I need a way of getting a handle on the embedded object as as Word.Application object so that I can use VBA to manipulate it.
Responses are appreciated.
I am using sheet.OLEObjects.Add to embed a Word document on a sheet. Excel seems to treat it as a Shape, and I can control only basics such as posistion and size of the object.
Manually, I can double click on the embedded object to edit it (insert text, etc). At this point, I am talking directly to Word.
How can I do this in VBA??? I need a way of getting a handle on the embedded object as as Word.Application object so that I can use VBA to manipulate it.
Responses are appreciated.