Excel for Mac - VBA to Create PowerPoint Presentation

[_p_j_b_]

Hi all,

I'm a Mac user. I'm trying to create a PPT using VBA in Excel to copy a few tables and charts to different slides.

However, whenever my script reaches PowerPoint commands, such as the one below, PowerPoint or Excel crash completely and close

Set pptPres = pptApp.Presentations.Add(msoFalse)

Having done some research, it looks like this is a known bug from a few years ago, but I'm wondering if anyone has found a workaround?

In case helpful, I have added the "Microsoft PowerPoint 16.3 Object Library" reference to my project.

Appreciate any help or advice anyone can provide on this -- thanks!

 

[Jim Gordon]

When I tested the code, I didn't get a crash, but I did get an "Object Required" message.