Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General PowerPoint Questions / June 2006

Tip: Looking for answers? Try searching our database.

VBA missing commands

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
K J Boland - 31 May 2006 15:51 GMT
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 - 31 May 2006 19:45 GMT
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

> having pulled the recent advice together, I now have a macro which goes
> through a presentation and changes the linked file references to relative
[quoted text clipped - 17 lines]
> 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.
K J Boland - 01 Jun 2006 18:05 GMT
> Dear KJ,
>
[quoted text clipped - 28 lines]
>> 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.
Steve Rindsberg - 31 May 2006 20:08 GMT
> 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
[quoted text clipped - 3 lines]
> However, as part of the main macro (which goes through the presentation mso
> by mso)

mso?  

> they do not show at all.

they?  which they is they?  ;-)

> 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).

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.

> 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.

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ:  www.pptfaq.com
PPTools:  www.pptools.com
================================================
K J Boland - 01 Jun 2006 18:05 GMT
thanks Steve...

>> 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
[quoted text clipped - 37 lines]
> PPTools:  www.pptools.com
> ================================================

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.