How can I disable Screen Updating of powerpoint FROM excel?
Application s File Name = "c:\some_folder\presentation.ppt" Set o PPTPres = o PPTApp. Open(s File Name, With Window:=mso False) ' Do your stuff Contents © 1995 - 2017 Stephen Rindsberg, Rindsberg Photography, Inc. You may link to this page but any form of unauthorized reproduction of this page's contents is expressly forbidden.
Hello, I have a macro that exports graphs from excel to powerpoint.
At Chandoo.org, I have one goal, "to make you awesome in excel and charting".
This blog is started in 2007 and today has 450 articles and tutorials on using excel, making better charts.
Open(str My File) With o Presentation Dim o Sl As Slide For Each o Sl In Active Presentation.
Advance Mode = pp Advance On Time ' End With Next o Sl End With o Presentation.
Before it would run in about 2-3 seconds per presentation, but as soon as the commented lines below are uncommented, the screen keeps refreshing 4 times per slide showing the slide animation preview (taking many more seconds).