excel emb embedded object

[mike]

I have an excel embedded object, that, when double clicked and the worksheet
is displayed, I would like to expand the display width so that two columns
can be viewed, instead of one, but I'm not having any luck.
If I expand the shape itself, it just spreads out the text.
Has anyone dealt with this before?
Thanks.

 

[JuneTheSecond]

After you double-click the shape, then the Excel object will be seen in
3-dimmensions. Then you can expand the frame of excel so that you can see
more cells.

 

[mike]

Yes, I know that, but I'd like to be able to do it programmatically.
Thanks.

 

[JuneTheSecond]

There is a ImgWidth cell in Foreign image Info.
When the ImageWidth cell is changed, the number of visibke cells changes.
How would you like to adjust this cell togather with shape width.

 

[mike]

What I'm trying to do is:
When the excel shape is double clicked, the excel worksheet opens, and a
column of English text that can be edited is displayed.
I want to add a button that when clicked, will widen the display of the
excel worksheet so that the original column of English text, and the next
column, which is a Spanish translation, is also displayed.

 

[JuneTheSecond]

To do so, you must access to the ActiveWindow of the excel object. But
embeded excel ole object has no window. So, I recommended you an alternative.

 

[mike]

That's what I was afraid of. Thanks for confirming that for me.