{"id":418,"date":"2011-09-24T20:35:51","date_gmt":"2011-09-24T20:35:51","guid":{"rendered":"http:\/\/paulgurney.com\/whats_new_blog\/?p=418"},"modified":"2011-09-29T15:53:41","modified_gmt":"2011-09-29T15:53:41","slug":"mac-powerpoint-how-to-export-text-from-slides","status":"publish","type":"post","link":"https:\/\/paulgurney.com\/whats_new_blog\/2011\/09\/mac-powerpoint-how-to-export-text-from-slides\/","title":{"rendered":"Mac PowerPoint How to Export Text from Slides"},"content":{"rendered":"<p>PDG is continually astounded at how unhelpful and unintuitive Microsoft programs can be. But thankfully in this case, my not-uncommon gripe has a happy ending.<\/p>\n<p>The unmet need, as framed as a typical google search query:<\/p>\n<h2><em>I want to export all of the text from a 20-page PowerPoint file to a plain text file.<\/em><\/h2>\n<p>Why? so that we can translate the text easily&#8230; or perhaps to proof read the text, or use the content in another medium, like in an email or Word document.<\/p>\n<p>Out of thousands of hits, only 1 website solved the problem. I&#8217;ll share with you the solution next.<\/p>\n<p>Thinking (wrongly) that surely PowerPoint 2008 for Mac lets us <strong>export the text from slides<\/strong>, I hunted for the option. First discovery: there is no export function. Okay, let&#8217;s try Save As&#8230; no, these options are useless, as the <strong><em>RTF outline text<\/em><\/strong> or <em><strong>HTML<\/strong><\/em> options do not export any slide <em>text<\/em>! Astounding.\u00a0 The &#8220;Outline&#8221; option requires some unusual structuring that ignores any actual content on the slides! And the &#8220;HTML&#8221; option actually <em>flattens all the text into a graphic<\/em>. Wow. Because in this SEO era, we surely don&#8217;t care about text-based content on our web pages, right?<\/p>\n<p>I found one helpful web page out of thousands that had a solution. It involves running a simple macro snippet, after adding it to the PPT file. I have never used Macros before, but I was able to figure it out in under 5 minutes.<\/p>\n<p><strong>But this technique does not work for POWERPOINT:MAC 2008<\/strong> \u2014 because Microsoft <em>removed<\/em> Macro support in Office 2008.\u00a0 Astounding again. Who does the thinking at the Mac Business Unit there?\u00a0 UPDATE:\u00a0 Macro support is back in Office 2011.<\/p>\n<p>However, luckily, I also have <strong>Office 2004<\/strong> for Mac. If you do too, follow along.<\/p>\n<p><a href=\"https:\/\/paulgurney.com\/whats_new_blog\/wp-content\/uploads\/2011\/09\/powerpoint-Mac-2004.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-428\" title=\"powerpoint Mac 2004\" src=\"https:\/\/paulgurney.com\/whats_new_blog\/wp-content\/uploads\/2011\/09\/powerpoint-Mac-2004.png\" alt=\"powerpoint Mac 2004\" width=\"394\" height=\"176\" srcset=\"https:\/\/paulgurney.com\/whats_new_blog\/wp-content\/uploads\/2011\/09\/powerpoint-Mac-2004.png 394w, https:\/\/paulgurney.com\/whats_new_blog\/wp-content\/uploads\/2011\/09\/powerpoint-Mac-2004-300x134.png 300w\" sizes=\"auto, (max-width: 394px) 100vw, 394px\" \/><\/a><\/p>\n<p>The website with the macro solution is here, at the <a title=\"PowerPoint FAQ site\" href=\"http:\/\/www.pptfaq.com\/FAQ00274.htm\" target=\"_blank\">PPT FAQ site<\/a>. Credit to Stephen Rindsberg, who modified code from Kris Lander.<\/p>\n<p>Copy the 2nd chunk of code. Here it is for you:<\/p>\n<blockquote>\n<pre>Sub ExportText()\r\n\r\n  Dim oPres As Presentation\r\n  Dim oSlides As Slides\r\n  Dim oSld As Slide         'Slide Object\r\n  Dim oShp As Shape         'Shape Object\r\n  Dim iFile As Integer      'File handle for output\r\n  iFile = FreeFile          'Get a free file number\r\n  Dim PathSep As String\r\n  Dim FileNum As Integer\r\n\r\n  #If Mac Then\r\n    PathSep = \":\"\r\n  #Else\r\n    PathSep = \"\\\"\r\n  #End If\r\n\r\n  Set oPres = ActivePresentation\r\n  Set oSlides = oPres.Slides\r\n\r\n  FileNum = FreeFile\r\n\r\n  'Open output file\r\n  ' NOTE:  errors here if file hasn't been saved\r\n  Open oPres.Path &amp; PathSep &amp; \"AllText.TXT\" For Output As FileNum\r\n\r\n  For Each oSld In oSlides    'Loop thru each slide\r\n    For Each oShp In oSld.Shapes                'Loop thru each shape on slide\r\n\r\n      'Check to see if shape has a text frame and text\r\n      If oShp.HasTextFrame And oShp.TextFrame.HasText Then\r\n        If oShp.Type = msoPlaceholder Then\r\n            Select Case oShp.PlaceholderFormat.Type\r\n                Case Is = ppPlaceholderTitle, ppPlaceholderCenterTitle\r\n                    Print #iFile, \"Title:\" &amp; vbTab &amp; oShp.TextFrame.TextRange\r\n                Case Is = ppPlaceholderBody\r\n                    Print #iFile, \"Body:\" &amp; vbTab &amp; oShp.TextFrame.TextRange\r\n                Case Is = ppPlaceholderSubtitle\r\n                    Print #iFile, \"SubTitle:\" &amp; vbTab &amp; oShp.TextFrame.TextRange\r\n                Case Else\r\n                    Print #iFile, \"Other Placeholder:\" &amp; vbTab &amp; oShp.TextFrame.TextRange\r\n            End Select\r\n        Else\r\n            Print #iFile, vbTab &amp; oShp.TextFrame.TextRange\r\n        End If  ' msoPlaceholder\r\n      End If    ' Has text frame\/Has text\r\n\r\n    Next oShp\r\n  Next oSld\r\n\r\n  'Close output file\r\n  Close #iFile\r\n\r\nEnd Sub<\/pre>\n<\/blockquote>\n<p>Now open the PPT file in PowerPoint:Mac 2004, open the menu item &#8220;Tools &#8211;&gt; Macros&#8221; and you will see the Macro editor. It will be empty at first.<\/p>\n<p><a href=\"https:\/\/paulgurney.com\/whats_new_blog\/wp-content\/uploads\/2011\/09\/PPT2004_macro.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-432\" title=\"PPT2004_macro\" src=\"https:\/\/paulgurney.com\/whats_new_blog\/wp-content\/uploads\/2011\/09\/PPT2004_macro.png\" alt=\"PowerPointt 2004 Macro dialog box\" width=\"385\" height=\"483\" srcset=\"https:\/\/paulgurney.com\/whats_new_blog\/wp-content\/uploads\/2011\/09\/PPT2004_macro.png 385w, https:\/\/paulgurney.com\/whats_new_blog\/wp-content\/uploads\/2011\/09\/PPT2004_macro-239x300.png 239w\" sizes=\"auto, (max-width: 385px) 100vw, 385px\" \/><\/a><\/p>\n<p>You will not see this macro like I show, at first; to begin, type in a simple name, then click CREATE.<\/p>\n<p>Copy\/paste the visual basic snippet into the new dialog\/edit box that appears, then SAVE it.<\/p>\n<p>Now you can RUN this macro. Voila. The exported txt file will be placed in the same directory as the PPT file itself.<\/p>\n<p>It worked seamlessly, without a hitch.<\/p>\n<p>And his script works for Mac and PC.<\/p>\n<p>Try it out! it saved me lots of manual copy\/paste time.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PDG is continually astounded at how unhelpful and unintuitive Microsoft programs can be. But thankfully in this case, my not-uncommon gripe has a happy ending. The unmet need, as framed as a typical google search query: I want to export all of the text from a 20-page PowerPoint file to a plain text file. Why? &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/paulgurney.com\/whats_new_blog\/2011\/09\/mac-powerpoint-how-to-export-text-from-slides\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Mac PowerPoint How to Export Text from Slides&#8221;<\/span><\/a><\/p>\n","protected":false},"author":55,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[27,19,28],"tags":[],"class_list":["post-418","post","type-post","status-publish","format-standard","hentry","category-computers-mac","category-computers-windows","category-publishing"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p415hC-6K","_links":{"self":[{"href":"https:\/\/paulgurney.com\/whats_new_blog\/wp-json\/wp\/v2\/posts\/418","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/paulgurney.com\/whats_new_blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/paulgurney.com\/whats_new_blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/paulgurney.com\/whats_new_blog\/wp-json\/wp\/v2\/users\/55"}],"replies":[{"embeddable":true,"href":"https:\/\/paulgurney.com\/whats_new_blog\/wp-json\/wp\/v2\/comments?post=418"}],"version-history":[{"count":21,"href":"https:\/\/paulgurney.com\/whats_new_blog\/wp-json\/wp\/v2\/posts\/418\/revisions"}],"predecessor-version":[{"id":425,"href":"https:\/\/paulgurney.com\/whats_new_blog\/wp-json\/wp\/v2\/posts\/418\/revisions\/425"}],"wp:attachment":[{"href":"https:\/\/paulgurney.com\/whats_new_blog\/wp-json\/wp\/v2\/media?parent=418"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/paulgurney.com\/whats_new_blog\/wp-json\/wp\/v2\/categories?post=418"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/paulgurney.com\/whats_new_blog\/wp-json\/wp\/v2\/tags?post=418"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}