VBA missing commands

[K J Boland]

having pulled the recent advice together, I now have a macro which goes
through a presentation and changes the linked file references to relative
references (hopefully).

As this takes some time I wanted to advise the user where we were in the
process (e.g Slide 8), without them having to press o.k each time. With
Steve and Shyam's advice I created a toolbar and button which can be updated
with the progress. These macro's work fine as alone.

However, as part of the main macro (which goes through the presentation mso
by mso) they do not show at all. The Input Box half clears off the screen,
and the macro runs through to the end ignoring the sub-routines to show the
toolbar (sometimes I can see an empty white area on the screen where the
toolbar should be).

I tried some delays (e.g 3 secs) at various points but this seems to make no
difference.

If I "stop" the macro at any point and go back to the screen, there is the
message tool bar- but if the macro runs through it doesn't show. As this is
not Excel and there isn't a screen method, I am at a loss.

 

[John]

Dear KJ,

You might want to add a "DoEvents" function within your loop, which allows
the operating system to complete other tasks (such as screen rendering).

Anyway, not guaranteed but worth a try.

All the best

John

 

[K J Boland]

thanks John, will try

Dear KJ,

You might want to add a "DoEvents" function within your loop, which allows
the operating system to complete other tasks (such as screen rendering).

Anyway, not guaranteed but worth a try.

All the best

John

 

[K J Boland]

thanks Steve...

they? which they is they? ;-)


Try dropping a DoEvents() (or more than one) at strategic places.
If you're moving from slide to slide, then right after the GoToSlide is a
likely place.



-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================