+ Reply to Thread
Results 1 to 4 of 4

Exporting pic in a slide to a folder

  1. #1
    Registered User
    Join Date
    07-24-2013
    Location
    Bratislava, SK
    MS-Off Ver
    Office Pro Plus 2016
    Posts
    42

    Exporting pic in a slide to a folder

    Hi guys,

    Sorry for the long post, but I need help for something really specific; if I had to do this by hand, it'd take me ages, so I'd like to try a macro instead.

    Back story:
    I have a PowerPoint presentation in which a number of slides display screenshots of an online app (the presentation is used to train newcomers). The presentation will need to be translated to other languages, including changing the screenshots (the online app is localised into multiple languages). I won't be doing the screenshots in multiple languages, as I don't have access to all language variations, so they'll be done by my colleagues elsewhere, whom I'm not in contact with. They'll send the screenshots back to me, and I'll incorporate them in their respective language versions.

    To avoid inconsistencies, I'd like to send the colleagues a folder with only the screenshots (not the entire slide, just that picture element), so that they can take the exact same screenshots. Sending them the PPT wouldn't work, because some of the images are only visible on screen for a short time because of animations, and explaining the selection pane and how to hide elements in it to see what's underneath would be an absolute pain.

    What I'd need a macro to do:
    The screenshots are inserted in a number of slides (in the selection pane, the screenshots are named "Picture X" where the X is a number; the name being assigned automatically by PPT when the image is pasted into the slide.) Only some slides show screenshots (some have a single image, some have multiple), others have no pictures at all.

    What I'd need is a macro to go through each slide; when it encounters an element named "Picture X", it makes a copy of the element and saves it as a PNG/JPG into a folder on the desktop. The filename of the saved pic should be the slide number (or in cases where there is more than one pic in a slide, it should save them as slide number + letter suffix. Note I don't want it to copy the slide itself, only the specific picture element.

    So as an example, if slide 13 has 2 pics copied into it, the macro would copy "Picture 1", save it in the "Pics" folder on the desktop, and name it "13", then it would copy "Picture 2", save it in the same folder and name it "13b", then it would do the same for the other slides. On slides where there are no picture elements, it would do nothing and move on to the next slide.

    I don't know how to do this in VBA in PPT (I'm not even sure it's possible). Any help would be very warmly appreciated, and would save me hours of mind-bendingly dull manual work.

    Thanks in advance,

    -Isa

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,314

    Re: Exporting pic in a slide to a folder

    I can't help with the macro but there is a way to extract the pictures - though they will just be named 'Image1' and so on. The instructions are here: https://support.office.com/en-gb/art...4-eab8a5bbc517
    When I tried it (Win 7 with Ppt 2010) the images all saved as .tmp files but I could open them all fine using an image editor.
    Regards,
    Aardigspook

    I've just moved house, internationally, during COVID (!) so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,598

    Re: Exporting pic in a slide to a folder

    change folder name to suit

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    07-24-2013
    Location
    Bratislava, SK
    MS-Off Ver
    Office Pro Plus 2016
    Posts
    42

    Re: Exporting pic in a slide to a folder

    Andy,

    It's perfect. Thank you so much, it works wonderfully.

    -Isa

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 05-02-2017, 07:10 AM
  2. Inserting Slides from Another Presentation Removes Slide Numbering & Footer on Slide
    By PSSMargaret in forum PowerPoint Formatting & General
    Replies: 2
    Last Post: 05-15-2016, 09:21 AM
  3. Copy and paste entire slide as an picture into new slide
    By Alistairm88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-02-2015, 10:29 AM
  4. Exporting a chart from Excel 2010 to a specific slide in PPT 2010
    By dodsonmrf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2013, 06:45 AM
  5. Replies: 1
    Last Post: 04-02-2012, 03:57 PM
  6. Select active slide by slide number in existing ppt through excel vba
    By amid in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-09-2009, 03:59 PM
  7. exporting data from Workbooks in Folder
    By juergenkemeter in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-22-2005, 08:46 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts