PowerPoint-tags in Excel
 

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

PowerPoint-tags in Excel
 

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 Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Brian Reilly, MVP" wrote in message
...
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

PowerPoint-tags in Excel
 

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

On Wed, 12 Sep 2007 21:22:27 -0400, "Jon Peltier"
wrote:

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 Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Brian Reilly, MVP" wrote in message
.. .
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

PowerPoint-tags in Excel
 

Do you still have these with the "new improved" Office 2007 shapes?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Brian Reilly, MVP" wrote in message
...
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

On Wed, 12 Sep 2007 21:22:27 -0400, "Jon Peltier"
wrote:

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 Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Brian Reilly, MVP" wrote in message
. ..
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

PowerPoint-tags in Excel
 

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

On Thu, 13 Sep 2007 18:50:24 -0400, "Jon Peltier"
wrote:

Do you still have these with the "new improved" Office 2007 shapes?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Brian Reilly, MVP" wrote in message
.. .
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

On Wed, 12 Sep 2007 21:22:27 -0400, "Jon Peltier"
wrote:

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 Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Brian Reilly, MVP" wrote in message
...
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