Hi Brian,

Thank you for your response.  I can re-create the charts/graphs in Excel.  I
inherited this PPT template, whoever created it originally chose MS Graph for
the charts/graphs.  I'll also check out the tags you mentioned.  Thanks
again, I'm sure I'll be back with more questions!

Todd Waldron
Austin, Texas

Hi Brian,

Thank you again for your response.  I'm open to using tags to update my
charts and graphs, however I'm really short on time to complete this project
and feel uneasy about trying to dive into a new concept this late in the
game.  Is there a way to continue by using the following approach (so I can
keep things consistent)?

For example, below is a section of code that I'm using to update a text box
on one of my slides:

***Code Start***

           'Copy the range from the Excel data file for Slide 6
           wksWorkSheet.Range("G1:G9").Copy

           'Paste the range from the Excel Data file to Slide 6
           appPPT.ActiveWindow.View.GotoSlide (6)

           With appPPT.ActiveWindow.Selection
               .SlideRange.Shapes("Rectangle 3").Select
               .ShapeRange.TextFrame.TextRange.Select
               .ShapeRange.TextFrame.TextRange.Characters(Start:=1,
Length:=24).Select
               appPPT.ActiveWindow.View.PasteSpecial (ppPasteText)
               .ShapeRange.TextFrame.TextRange.Characters(Start:=1,
Length:=17).Select
               .TextRange.Font.Size = 16
               .ShapeRange.TextFrame.TextRange.Paragraphs(Start:=1,
Length:=9).ParagraphFormat.Alignment = ppAlignRight
               .Unselect
           End With

***Code End***

My approach so far has been to copy the new data from my Excel data file,
then in the PPT, navigate to the corresponding slide, navigate to the
corresponding slide object, access the slide object, and paste the new data.

The fixed slide object types in my presentation template include:
Text Boxes
Excel DataSheets (displayed)
Excel Graphs (with underlying Excel DataSheet)
Excel Charts (with underlying Excel DataSheet)

My only hurdle at this point is learning how to update the Excel objects.

For example, on one slide I have two different objects, an Excel DataSheet
(displayed) and an Excel Graph (with underlying Excel DataSheet), both of
which need to be updated.  In this case how do I access the Excel objects,
and how do I differentiate between the displayed Excel datasheet and the
underlying datasheet for the graph?  Would you be so kind as to provide an
example of how you would approach this using the method I'm describing, or an
example using the tags as you've described?  I would be most grateful.

Thank you,

Todd Waldron
Austin, Texas

Hi Steve,

Thank you for your response, your sites have a lot of great stuff!  For this
particular problem I think I'll re-create the charts/graphs in Excel so they
will be easier to work with.  Thanks again.

Todd Waldron
Austin, Texas

I am trying to link an excel file and a powerpoint file, so that if i
change some cells in excel (let's say a number within a cell ) , the
powerpoint will update with that number (eg.: "the weather on sunday
was [0C]"). Note that the text (weather on sunday was) is typed in
powerpoint and the only link item would be "0C".

I have noticed that this can be possible within microsoft word (paste
special -> Paste Link -> Unformatted text) but this option is not
available within Powerpoint.

does anyone have a solution?

many thank in advance