Why is VBA unable to open any PowerPoint presentation which has flash in it?

[Colin McBride]

Please help me if you can!

The problem is that whenever I open a PowerPoint presentation using
VBA, (which contains any flash element) the presentation opens but the
VBA code then instantly ends.

This only appears to be a problem when you open the document, if the
document is opened manually you can run any VBA code it works fine.

We have tested this on different versions of Windows and Office and it
seems to happens on all of them.

We have also tried recording a very simple Macro using the built-in
Record Macro tool, which simply opens the presentation and copies and
pastes a box within the presentation. When you then re-run this macro
it will always open the presentation, but crash out of the macro before
it gets to copy the box.

Any idea on how I can get more information about the problem and/or fix
it.

Thanks
Colin

(e-mail address removed)

 

[Brian Reilly]

Colin,
Off the top of my head, the rest of the code is executing while the
presentation is still opening it. Try counting the open presentations
before the FileOpen command and wrap a dowhile loop around the
FileOpen while the Presenttions.open.count <>=
Presentations.open.count + 1

Brian Reilly, MVP

 

[Steve Rindsberg]

The problem is that whenever I open a PowerPoint presentation using
VBA, (which contains any flash element) the presentation opens but the
VBA code then instantly ends.

This only appears to be a problem when you open the document, if the
document is opened manually you can run any VBA code it works fine.

We have tested this on different versions of Windows and Office and it
seems to happens on all of them.

We have also tried recording a very simple Macro using the built-in
Record Macro tool, which simply opens the presentation and copies and
pastes a box within the presentation. When you then re-run this macro
it will always open the presentation, but crash out of the macro before
it gets to copy the box.

I know that one of the regulars here ran into that problem around the time
PPT2003 was released. If there was flash content in the presentation, the copy
method would cause the macro to just stop. No errors or anything just ...
nothingness.

Have you tried updating PPT with the latest service packs? Choose Help, Check
For Updates and let it rip.