VBA graphing animation problem

[Martin Conradi]

In XP/2003 I have a slide with an animated headline and a vertical bar chart
where the individual bars appear on a button click. I am putting in the
values for the bar chart from another page using vba during the presentation
(i.e. while 'live' in show mode).

I need to repeat the process several times, always using the same bar
chart - but although I can get the values to display each time, I cannot get
the animation to repeat.

If I put a blank page ahead of the chart with a 0 second transition, I get
all the animation back; but this isn't an option as I need to be able to
jump back from the chart to 'last page viewed' (and this only takes me back
to the blank page).

Any thoughts gratefully received!

Martin

 

[John Wilson]

Since you are using vba you could use vba to link to the slide

Sub jump()
ActivePresentation.SlideShowWindow.View.GotoSlide 5, msoTrue
End Sub

Obviously change the slide number

You might also want to read
http://www.pptalchemy.co.uk/powerpoint_hints_and_tips_tutorials.html#custom
--
Amazing PPT Hints, Tips and Tutorials

http://www.PPTAlchemy.co.uk
http://www.technologytrish.co.uk
email john AT technologytrish.co.uk

 

[David M. Marcovitz]

There are some potential VBA solutions to this:

(1) You can change your navigation to use VBA. Thus, you can keep track
of whatever you want. For example, you could have a button that links to
the blank slide and sets a variable to the slide number of that slide.
Then, the return button doesn't use Last Slide Viewed, it uses a VBA
script to check the value of that variable.

(2) Another, probably simpler, alternative is to use VBA to jump
directly to the graph slide using
ActivePresentation.SlideShowWindow.View.GotoSlide. One of the parameters
of GotoSlide is whether or not you want to reset the slide, which is
what you want. It would make sense to have this capability without VBA,
but it isn't there.

(3) Another alternative without VBA (you'll have to test it because I
don't know if it will work) is to put the graph slide in a custom show.
Instead of linking to the slide, link the show, being sure to check the
option for Show and Return. Then, instead of Last Slide Viewed, use End
Show to return. I know this will work for the navigation, but I don't
know if it will reset the animation or not.

--David

 

[Martin Conradi]

Thanks - we've gone the vba (2) route - but the custom show also works fine.

Martin

 

[David M. Marcovitz]

Great. Thanks for letting us know that it worked.
--David