+ Reply to Thread
Results 1 to 2 of 2

Excel VBA to save PPT shapes as PNG images

  1. #1
    Registered User
    Join Date
    05-29-2014
    Posts
    1

    Excel VBA to save PPT shapes as PNG images

    I have an Excel (.xlsm) that opens an existing PPT and uses VBA to modify several slides.
    There are several shapes on each slide and my .xlsm has VBA that modifies those shapes.
    (The slides have designs on them for different size business cards which get filled in with spreadsheet names,...)

    Now I want to "select all" the shapes on a slide as a "group"(not sure that term is correct).
    Then I want to export that group as a .PNG image file.
    Save location can be the same folder location of the .xlsm file (doesn't really matter).

    This is different than exporting each slide as a .PNG.(which I can already do).
    In this case the business card designs on each slide are different sizes.
    So I need the images to be just the size of the "group" on that slide.

    The VBA code is within the .xlsm file (not the PPT)
    Several posts show VBA code for within the .pptm file that works fine
    if using just a PPT
    However that code doesn't seem to work when I put it in the .xlsm file to drive
    the image creation from Excel.

    ======================

    PC with latest of all software.

    Pulling my hair out on this one.
    Can anyone help.

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

    Re: Excel VBA to save PPT shapes as PNG images

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

+ 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. How to save Linked images on excel as embedded images.
    By jonelamora in forum Excel General
    Replies: 0
    Last Post: 04-18-2013, 10:29 PM
  2. inserting images and shapes using macros
    By Suraj3825 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2013, 03:58 PM
  3. Excel cannot save file with imported images?
    By eDIN in forum Excel General
    Replies: 2
    Last Post: 09-07-2012, 03:26 PM
  4. [SOLVED] Move all selected shapes (images,textbox,etc) simultaneously
    By jonelamora in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-25-2012, 04:54 AM
  5. Replies: 1
    Last Post: 06-23-2005, 07:05 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1