Excel VBA / Powerpoint crash problem

Hello,

I'm struggling with a strange problem. I'm writing some Excel VBA to perform some analysis on a large batch of PowerPoint presentations that I'm working on. I ultimately want to generate a worksheet for each presentation with some stats on it - number of slides, number of shapes on each slide etc.

The issue I'm having, however, is much more fundamental - it keeps crashing for some reason, and it's always when I'm making use of slide objects. For example:

Please Login or Register  to view this content.

That last line will trigger a crash, every time. It doesn't matter what I actually refer to - I've just used slide 8 as an example here. Any use of ppSlide, or any attempt to refer to a specific slide in the presentation, will crash Excel.

I'm using Mac OS X High Sierra 10.13.6, and Excel 16.16.1

All help gratefully appreciated!

What happens if you try a debug.print of:

ppPres.slides.count ?

Do you really have 8 slides in your presentation?

I also see in the Power Point object model there is a "Slide" object as well as a "Slides" object
https://docs.microsoft.com/en-us/off...t/object-model

Perhaps you have an illegal dim where you are trying to use one of those reserved words as a variable?

Have you had success on the Mac as well as the PC platform?

In my experience a crash is very rare and many times I'm trying to use a word that is reserved and should not be used as I'm trying to use it.

If you can display the "Object Browser" for PowerPoint, you can see all the Object names and most of them are reserved. Perhaps you can find the one that is killing your code.

Hi Big B,

I only know the PC and don't have a Mac. Maybe one of the Mac Excel Guru's will have an idea on this one.