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:

Option Explicit

Sub Analysis()

Dim ppApp As PowerPoint.Application
Dim ppPres As PowerPoint.Presentation
Dim ppSlide As PowerPoint.Slide
Dim ppShape As PowerPoint.Shape
Dim FileName As String

FileName = Application.GetOpenFilename
Set ppApp = New PowerPoint.Application
ppApp.Visible = True

Set ppPres = ppApp.Presentations.Open(FileName)

Set ppSlide = ppPres.Slides(8)

end sub

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.