PowerPoint-tags in Excel

  • Thread starter Thread starter Brian Reilly, MVP
  • Start date Start date
B

Brian Reilly, MVP

Hi folks who know the use of tags in PowerPoint,

I have presentations in PowerPoint using MSGraph 2003 and here's what
I want to do via VBA.

This part I understand how to do: Get the data from the MSGraph
datasheet into an Excel worksheet.

I want to create the chart in XL using a Library of charts. That I can
do as well.

I'd like to automatically re-insert the XL chart back into PPT on
correct page and correct size. I suppose I could write the appropriate
values to the Excel worksheet and go delete the original chart in PPT
and size correctly. Anyone have any better ideas? Is there a tag-like
functiionality in XL like there is in PPT?

Brian Reilly, PowerPoint MVP
 
Brian -

I'm not too familiar with tags, except for being jealous that you guys got
em and we ain't. I would follow the same scheme that you're describing.
Don't delete the old chart until you know the new one has taken.

- Jon
 
Jon,
Thanks for the advice.

Yes tags are wonderful. I've almost stopped using shape names in favor
of tags which store two properties, a name and a value. And you can
literally have thousands of them attached to a shape. It's sort of
like have two XL columns to store variables in like
Top 42

Brian Reilly, PowerPoint MVP
 
Jon,
Yes, a shape is a shape even in Office 2007. Other stuff has changed
(g) but they didn't delete any of the old stuff. Check out the
PPTFAQ.com page and search on tags for more information. They are
really good things to know about if you are coding in PPT.

Brian Reilly, PowerPoint MVP
 
Back
Top