test box link to excel cells

[fresnobee]

is there a way that i can link the content of my text box in Powerpoint to
the value in the cell of my excel spreadsheet?

 

[PPTMagician]

Select the cell in the spreadsheet, click on Edit, Copy

Click inside the PowerPoint Text Box, click on Edit, Paste Special and when
prompted select Paste Link.

 

[fresnobee]

That is working. But it created picture objects linked to the Excel cell. I
am trying to find a way that i can do this in VBA and have my text box in
Powerpoint linked to excel cell.

 

[fresnobee]

I did paste link as Excel object. it appear to be a picuture object, but it
is not a picture exactly. you can resize it but you cannot rotate it.

In powerpoint, every time i create a text box, it assigns a text box number
to it, and it seems that i don't have a control over the assigned number(i
cannot change it). I have a graphy in Powerpoint and labeled with those text
boxes. What i am trying to do is to link the content of the text box to the
cell value in my excel spreadsheeet.

I am using office 2003.

Thanks!

 

[Brian Reilly, MVP]

When you pastelink a range from XL into PPT, it is not pasting the
content into a PPT textbox but into an OLE object, which cannot be
rotated inside of PPT. If you want rotated text you have to rotate it
in XL and that formatting will flow through to PPT since that cell and
its formatting is what PPT is displaying.

Brian Reilly, MVP