control PowerPoint from Access
Posted on 2006-04-04
I have a sub routine in Access that creates a table on a PowerPoint Slide and then pastes a couple of graphs from an Access graph object onto the slide below the table.
The use has the option of doing this in an open PowerPoint presentation or of creating a new PowerPoint presentation.
When they choose the alread open PowerPoint presentation, it works fine.
But, if they choose a new Powerpoint presentation, I want all the action to happen out of sight. While creating the table, everything works, but to paste in the graphs, I must first activate the PowerPoint application so I can access the active window. This causes the PowerPoint presentation to flash to the front of the screen and then go to the background and the document is left open.
When controlling Word, I can set ScreenUpdating to false to avoid this.
What is the equivalent technique in PowerPoint?