test box link to excel cells

[Guest]

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?

 

[Guest]

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.

 

[Guest]

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.

 

[Steve Rindsberg]

That is working. But it created picture objects linked to the Excel cell.

Are you sure you did Paste Special, put a check next to Link and made sure that
you chose Excel object (or whatever it's called) and not HTML?

That's never produced a picture in any version of Excel/PPT I've used, going back
to Office 4.

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.

Ah. VBA. You left out a few bits of the puzzle! ;-)

What version of Office?
The PasteSpecial isn't exposed in PPT until version 2002 or 2003.

 

[Guest]

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!

 

[Steve Rindsberg]

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.

But doubleclick it. That should either launch the source file in Excel or open it
"in-place" for editing within PPT.

And if you change the linked content in the excel file then reopen the presentation,
it should update.

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).

PowerPoint assigns a name to every new shape it creates, but you can change that via
VBA by changing the .Name property.

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.

More and more bits of the puzzle. It would help if you gave us the whole picture at
once. ;-)

Is the graph from Excel or MSGraph (the app that gets called up to create graphs when
you Insert a chart from within PPT)?

Are your text labels drawn in PPT and sitting ATOP the graph or ???

 

[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