tag:blogger.com,1999:blog-7094652.post2935167722718584019..comments2024-03-23T14:36:09.980+00:00Comments on Neil Mitchell's Blog (Haskell etc): PowerPoint -> PDF (Part 2)Neil Mitchellhttp://www.blogger.com/profile/13084722756124486154noreply@blogger.comBlogger46125tag:blogger.com,1999:blog-7094652.post-54713523838922654922021-02-22T21:47:27.444+00:002021-02-22T21:47:27.444+00:00I just had to wait very long, it worked!I just had to wait very long, it worked!Anonymoushttps://www.blogger.com/profile/06182021730705226862noreply@blogger.comtag:blogger.com,1999:blog-7094652.post-45195016506651910282021-02-22T21:41:00.114+00:002021-02-22T21:41:00.114+00:00Dear Sir, thank you so much !
The only problem is...Dear Sir, thank you so much !<br /><br />The only problem is that powerpoint keeps going into "program not responding any more"<br />I need to convert 108 slides into pdfs by tomorrow, you happen to have any experience why powerpoint becomes non responsive after launching the code? thank youAnonymoushttps://www.blogger.com/profile/06182021730705226862noreply@blogger.comtag:blogger.com,1999:blog-7094652.post-60404760407602359902020-11-24T07:22:20.102+00:002020-11-24T07:22:20.102+00:00Thank you so much, that was easy!Thank you so much, that was easy!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7094652.post-60471774487113360332019-08-25T06:59:23.426+01:002019-08-25T06:59:23.426+01:00how to convert pdf to powerpont and enable edited ...how to convert pdf to powerpont and enable edited file?Simontokhttp://simontok.getxid.comnoreply@blogger.comtag:blogger.com,1999:blog-7094652.post-84340722043151923902019-05-20T13:56:43.444+01:002019-05-20T13:56:43.444+01:00Taylor - no course of similar - I'm an ex VB5-...Taylor - no course of similar - I'm an ex VB5-6 programmer who got into it that way.Neil Mitchellhttps://www.blogger.com/profile/13084722756124486154noreply@blogger.comtag:blogger.com,1999:blog-7094652.post-78670227961675073302019-05-16T13:29:15.058+01:002019-05-16T13:29:15.058+01:00Thanks Neil...
By expand on it, I just meant advi...Thanks Neil...<br /><br />By expand on it, I just meant advise people how to install and run VBA (which not a lot of people have done before).<br /><br />Thanks for the confirmation, I will link to it from my post.<br /><br />totally other random question, do you have a course on building macros in PowerPoint by chance? I get asked about this occasionally and don't know of anyone who really has one.<br /><br />Thanks again,<br />TaylorTaylorhttps://www.blogger.com/profile/03074008724473102940noreply@blogger.comtag:blogger.com,1999:blog-7094652.post-55240224248201099972019-05-12T14:30:43.780+01:002019-05-12T14:30:43.780+01:00Thanks Taylor - it doesn't require Adobe eleme...Thanks Taylor - it doesn't require Adobe elements or anything beyond basic PowerPoint. I assume it still works, but don't use PowerPoint much anymore. Happy for you to take it and expand as you wish. https://github.com/ndmitchell/office/blob/master/PowerFlat.bas Is my latest version. Neil Mitchellhttps://www.blogger.com/profile/13084722756124486154noreply@blogger.comtag:blogger.com,1999:blog-7094652.post-705131892031547162019-05-09T08:04:15.559+01:002019-05-09T08:04:15.559+01:00Hi Neil,
I'm not a VBA expert (so apologies i...Hi Neil,<br /><br />I'm not a VBA expert (so apologies if these are dumb questions):<br /><br />1. For your code to work, do you have to have an Adobe elements (or other) subscription? I.e. can anyone run this code, or do you have to have a subscription?<br /><br />The reason I ask is, I just published a post on converting PowerPoint to PDF and one of my points was that animations do not carry over (which is something I'm often asked).<br /><br />If this does work for anyone (which would be amazing), I would love to include a link back to your code or even expand on it for people who are not fluent in VBA so they can FINALLY make this a reality.<br /><br />Below is the blog post I created for reference.<br />https://nutsandboltsspeedtraining.com/powerpoint-tutorials/ppt-to-pdf/<br /><br />Would love to get your insight so I can refer people back to this assuming it works for everyone.<br /><br />Thanks!<br />Taylor<br /><br /><br />Taylorhttps://www.blogger.com/profile/03074008724473102940noreply@blogger.comtag:blogger.com,1999:blog-7094652.post-5262651296737899592018-05-23T20:55:15.418+01:002018-05-23T20:55:15.418+01:00Thanks Philipp - very cool! I would have updated t...Thanks Philipp - very cool! I would have updated the blog to include a link to your code, but unfortunately any edits to the page make it break (I guess something about blogger changed in the last decade...)Neil Mitchellhttps://www.blogger.com/profile/13084722756124486154noreply@blogger.comtag:blogger.com,1999:blog-7094652.post-24872270733180624682018-05-20T20:06:08.801+01:002018-05-20T20:06:08.801+01:00Here is how you can use this code and retain the s...Here is how you can use this code and retain the slide numbers from the old presentation:<br /><br />https://gist.github.com/pcmoritz/4b0e1be7f2dfcc4e51e2ace50426f67d<br /><br />You need to deactivate the slide numbers, this will insert a text box per slide with the right number from the old slide.Philipp Moritzhttps://www.blogger.com/profile/04399819734152389526noreply@blogger.comtag:blogger.com,1999:blog-7094652.post-59687192189606230822017-09-11T02:40:49.797+01:002017-09-11T02:40:49.797+01:00Thank you!!Thank you!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7094652.post-20589093070597591752017-07-15T19:05:05.207+01:002017-07-15T19:05:05.207+01:00Wow. I've never run a macro, used VBE etc. I h...Wow. I've never run a macro, used VBE etc. I had to hunt a bit through confusing crap on MS Support to stumble into what I should do to use your code on PowerPoint for Mac 2016. But it worked. Thank you so much. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7094652.post-89928440250840164882017-06-04T17:01:30.382+01:002017-06-04T17:01:30.382+01:00As it is always the case, there is still room for ...As it is always the case, there is still room for improvement.<br />One thing that does not work with macro are page numbers. All added slides get new page numbers and don't retain the same numbers as they would have in the original.Anonymoushttps://www.blogger.com/profile/00923799901340936170noreply@blogger.comtag:blogger.com,1999:blog-7094652.post-8564402964902656402017-04-20T05:09:12.144+01:002017-04-20T05:09:12.144+01:00The script even works in PowerPoint 15 on macOS, h...The script even works in PowerPoint 15 on macOS, however it is (like other commented) not able to split animated bullet point lists into single items. As a Mac user I just found out that (the meanwhile free) Apple Keynote can read PowerPoint pretty well and Keynote is able to export really reach animation to PDF. So lucky am I and others using a Mac. Sensorgrafie.dehttps://www.blogger.com/profile/16095645543590528627noreply@blogger.comtag:blogger.com,1999:blog-7094652.post-47594821558294757332016-03-30T20:58:57.029+01:002016-03-30T20:58:57.029+01:00For those wondering. post the code into a VB modul...For those wondering. post the code into a VB module or open your macro menu, type in a AddElements to the Macro Name and click "create" then paste the code in the window the VB code editor window that comes up. Close and return, then you should see the two macros (addElements and RemElements) listed in your macro list.Jamihttps://www.blogger.com/profile/07924240934309233680noreply@blogger.comtag:blogger.com,1999:blog-7094652.post-56906314453022456032016-03-30T20:56:53.085+01:002016-03-30T20:56:53.085+01:00Pure Genius! thank you sooo much!!
Pure Genius! thank you sooo much!!<br /><br />Jamihttps://www.blogger.com/profile/07924240934309233680noreply@blogger.comtag:blogger.com,1999:blog-7094652.post-84938777095436369452015-10-12T13:17:08.911+01:002015-10-12T13:17:08.911+01:00Where do I paste the code? Please anyone describe ...Where do I paste the code? Please anyone describe exactly (Mac Yosemite; PPT 14.4.5 2011 for mac). Thx!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7094652.post-62804753150236768212015-08-30T14:21:21.756+01:002015-08-30T14:21:21.756+01:00Mac users say: god bless you!
It's amazing ho...Mac users say: god bless you!<br /><br />It's amazing how 8 years later MS still haven't sorted this out (I think keynote has an option to break animations up when creating a PDF). In particular, the few scripts I could find out there are all for windows, so your script is a real life-saver for us OSX users.<br /><br />Minor issue: when using text animations (i.e. just having bullet points appear one by one), the script will break the slide into multiple slides, but will keep all bullet points in every slide (rather than adding a new bullet point to each slide), requiring one to go and manually delete some bullet points. Still, small price to pay compared to having to do everything manually!<br /><br />Thanks!!!!!!!!<br /><br />p.s. - tested on OSX Yosemite running MS PowerPoint 2011 for mac.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7094652.post-86483907815890210072015-07-02T17:19:39.858+01:002015-07-02T17:19:39.858+01:008 years later, still works a charm! Thanks a lot! ...8 years later, still works a charm! Thanks a lot! Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7094652.post-50834594827506424232015-02-19T21:04:51.516+00:002015-02-19T21:04:51.516+00:00Sebastien, no idea I'm afraid - I don't ev...Sebastien, no idea I'm afraid - I don't even have PowerPoint installed on this machine anymore.Neil Mitchellhttps://www.blogger.com/profile/13084722756124486154noreply@blogger.comtag:blogger.com,1999:blog-7094652.post-67420778151965435442015-02-19T13:07:20.262+00:002015-02-19T13:07:20.262+00:00Hi,
I had a similar idea and cannot find why I h...Hi,<br /> <br />I had a similar idea and cannot find why I have errors. The idea was to create a macro opening all my .pptx within a specified folder and create two kinds of pdfs from these.<br />Note: these pdf are password protected.<br /> <br />However I am now blocked as it works fine for the 1st powerpoint and then it crashes for the second telling me that the Exportasfixedformat does not work.<br />Would you have any tips for me, please?<br /> <br /> Public wbPPT As Presentation<br /> Public fPPT As String<br /> Public fInput As String<br /> Public fpath As String<br /> <br /> <br />Sub BatchBuilding_pdf_from_PPT()<br /> <br /> Dim nfichier As String, nfichier2 As String, intpos As Byte<br /> <br /> <br /> fInput = InputBox("Please enter the local address where are stored your PPT files (e.g. C:\... ) ")<br /> If fInput = "" Then<br /> MsgBox ("No path entered, the Importing process is cancelled")<br /> Exit Sub<br /> Else<br /> If Right(fInput, 1) <> "\" Then<br /> fInput = fInput & "\"<br /> Else<br /> fInput = fInput<br /> End If<br /> <br /> fpath = fInput<br /> <br /> fPPT = Dir(fpath & "*.pptx")<br /> <br /> Do While Len(fPPT) > 0<br /> <br /> nfichier = fPPT<br /> 'find where is the extension in the name<br /> intpos = InStrRev(nfichier, ".")<br /> 'replace the pptx by pdf<br /> nfichier = Left(nfichier, intpos - 1)<br /> nfichier2 = nfichier & ".pdf"<br /> <br /> With ProtectedViewWindows.Open(fpath & fPPT, "password").Edit("password")<br /> .ExportAsFixedFormat Path:=fpath & "Without notes\" & nfichier2, FixedFormatType:=ppFixedFormatTypePDF, Intent:=ppFixedFormatIntentPrint, FrameSlides:=msoTrue, PrintHiddenSlides:=msoTrue, OutputType:=ppPrintOutputSlides<br /> .ExportAsFixedFormat Path:=fpath & "With notes\" & nfichier2, FixedFormatType:=ppFixedFormatTypePDF, Intent:=ppFixedFormatIntentPrint, FrameSlides:=msoTrue, PrintHiddenSlides:=msoTrue, OutputType:=ppPrintOutputNotesPages<br /> .Close<br /> End With<br /> <br /> fPPT = Dir<br /> <br /> 'same code as before to prepare for the next file (just in case)<br /> nfichier = fPPT<br /> 'find where is the extension in the name<br /> intpos = InStrRev(nfichier, ".")<br /> 'replace the pptx by pdf<br /> nfichier = Left(nfichier, intpos - 1)<br /> nfichier2 = nfichier & ".pdf"<br /> <br /> Loop<br /> <br /> MsgBox ("All presentations have been PDFied")<br /> End If<br /> <br />End Sub<br /> <br />Thanks in advance.Anonymoushttps://www.blogger.com/profile/07756184918122075392noreply@blogger.comtag:blogger.com,1999:blog-7094652.post-82033943685551537362012-11-14T14:57:18.692+00:002012-11-14T14:57:18.692+00:00Hello,
Thanks for this tip that is really useful....Hello,<br /><br />Thanks for this tip that is really useful. <br /><br />Just a drawback: the incrementation of the slides numbers :-( (my final slide is slide # 99/15) <br /><br />Do you have a trick to avoid this? <br /><br />Thanks in advance ;-)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7094652.post-898113937981077902012-11-14T14:56:47.808+00:002012-11-14T14:56:47.808+00:00Hello,
Thanks for this tip that is really useful....Hello,<br /><br />Thanks for this tip that is really useful. <br /><br />Just a drawback: the incrementation of the slides numbers :-( (my final slide is slide # 99/15) <br /><br />Do you have a trick to avoid this? <br /><br />Thanks in advance ;-)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7094652.post-29735444856996498492012-08-13T17:37:46.125+01:002012-08-13T17:37:46.125+01:00Hi Neil.
I had difficulty to get this into Powerp...Hi Neil.<br /><br />I had difficulty to get this into Powerpoint2010. Cant find the button to paste this code. <br /><br />Your assistance is highly appreciatedDHorlhttp://nanoreply@blogger.comtag:blogger.com,1999:blog-7094652.post-43758253554328063662012-04-09T18:08:58.516+01:002012-04-09T18:08:58.516+01:00Great script! Thanks! One problem is that page num...Great script! Thanks! One problem is that page numbering is not retained. Any suggestions???Unknownhttps://www.blogger.com/profile/03920583473280357149noreply@blogger.com