Creating PowerPoint Presentation with VBA Fails Randomly

I could not get the application to fail, but I have a fairly fast machine with a lot of RAM.

The only suggestion I can offer is to add DoEvents after each paste. DoEvents causes Excel to stop execution until things catch up. It's sometimes needed when talking with other applications. What might be happening is that Excel is busy pasting and PowerPoint is busy being pasted when Excel comes across the next copy command in the loop.

I'll try it on a slower machine to see if I can duplicate the issue.

I ran it on my slower machine. It ran slower, but I still can't get it to fail.

Another thought I have is that something else might be competing for the windows clipboard at the same time. My first thought was that it was competing with itself which is why I suggested DoEvents.

A bit off topic. I have a similar program where I provide a "template" presentation. It is not a real template, it's a "blank" presentation with the "boilerplate" in place. I use an Excel Table to tell the program what excel sheet to go to, what range or chart to copy, which page to put it on in the presentation, where to locate it and how to size it. It works well with "fixed" templates which fortunately, most of my work is.

I am looking at your code with an eye to create a presentation, "from scratch" adding slides as I go along.

Have you tried to put DoEvents after the Copy?

I took a deeper look into your code and I found a difference in how you paste in this application and how I paste in my application

You

Please Login or Register  to view this content.

Me

Please Login or Register  to view this content.

Also I am attaching my application (with documentation). I suggest that you might want to use an excel table to drive what gets copied and where it gets pasted and positioned and sized, rather than repeat it in the code. I would be interested in doing a "hybrid" application using your techniques for adding sheets as needed and my reading specifications from an Excel Table.