I'm automating a powerpoint presentation from a Microsoft Access database.
On my development PC it works perfectly.
In the real environment (with brand new PC's) it will sometimes work and at other times fail with odd error messages but at different locations in the code with the same data.
Turning anti virus off makes no difference.
I've stuck some code in to slow Access down and that seems to cure it or at least temporarily cure it.
To me it looks like powerpoint is not always able to complete an action before Access is giving it the next task. A timing problem.
Set objPwrPnt = CreateObject("Powerpoint.application")
So is there a way to determine if objPwrPnt is busy (or idle) ?