PDA

View Full Version : starting powerpoint slideshow from vba



blastman
03-07-2008, 03:37 AM
I'm new here, so first thing's frist...

Hello. :thumb

I have 3 machines dotted around the office that run powerpoint slide shows. I'd like to be able to email the slideshow to the machine's and have outlook save, open and run the slideshows for me.

I can already do all of this but I'm having problems when the vba code exit's. It seems to close PowerPoint as well.

I require the code to exit so that it can start the process again when the next mail comes in, however PowerPoint once started in this way won't stay open after the code exit's.

I have tried adding a do until loop in so the slideshow keeps running, but that doesn't work as the code is still looping and so doesn't recognises that a new mail has come in (with update slideshow to be played)


Is there anyway of starting PowerPoint with my settings for the slideshow and then exit the code without closing PowerPoint??

Or, is there a way of looping at the bottom of the 'open_PowerPoint' sub but still have the 'do events' of the incoming mail triggered??


cheers in advance.