Excel vba open powerpoint file

Actually I need to do a great deal more than just open the PowerPoint file - but I was just trying to keep my query focused in the first instance. FYI after opening the file, I want to sequentially skip through the slides in the file, and on each slide i identify charts ii for each chart, open the datasheet and make various changes to the datasheet iii then move the location of some shapes to re-align their location relative to the bars or whatever in the chart.

In response to John Korchok Hi John The problem is actually opening the file. Application" MyPPT. But having opened the file this way, I ground to a halt in trying to even do something simple like, in the first instance, identify how many slides there are in the file by using 'ActivePresentation. So I started doing more searching and came across the concepts of 'early binding' and 'late binding' - which was a bit of revelation for a novice like me!!

Save ObjPptApp. Post you may like Replace a string in all the excel files in a folder using VBA. Uncategorized ActivePresentation.

AddTextbox , change font size of textbox text in slide vba , Create a text box on a slide using cell data from excel sheet vba , create powerpoint slides from excel data vba , excel automation , Excel macro , macro , Open PPT presentation from excel vba , powerpoint automation , powerpoint vba set textbox text value , powerpoint vba set textbox value from excel , powerpoint vba textbox object , VBA , vba powerpoint textbox properties.

You may also like Read Full Post. Community Bot 1 1 1 silver badge. Prasath Kv Prasath Kv 31 1 1 silver badge 2 2 bronze badges. You've made certain that the value in pptpath is correctly formatted and that the file's where you say it is, I'll assume. But is the file password protected and are you certain it's not corrupt? Add a comment. Active Oldest Votes.

Open pptpath PP. Sign up or log in Sign up using Google. Sign up using Facebook. Site: greatcirclelearning. Threats include any threat of suicide, violence, or harm to another. Any content of an adult theme or inappropriate to a community web site. Any image, link, or discussion of nudity. Any behavior that is insulting, rude, vulgar, desecrating, or showing disrespect. Any behavior that appears to violate End user license agreements, including providing product keys or links to pirated software.

Unsolicited bulk mail or bulk advertising. Any link to or advocacy of virus, spyware, malware, or phishing sites.

Any other inappropriate content or behavior as defined by the Terms of Use or Code of Conduct. Any image, link, or discussion related to child pornography, child nudity, or other child abuse or exploitation. Details required : characters remaining Cancel Submit 1 person found this reply helpful.