+ Reply to Thread
Results 1 to 4 of 4

VBA to Pull an image from PPT into Excel as an enhanced metaframe picture

  1. #1
    Registered User
    Join Date
    01-19-2017
    Location
    NYC
    MS-Off Ver
    2016
    Posts
    10

    VBA to Pull an image from PPT into Excel as an enhanced metaframe picture

    Have a power point that is fed a set amount of tables each month. Would like to set up a macro to pull in these tables into an excel file that I then convert to a pdf. (only need a macro to pull the tables in)

    I would like to be able to specify the tab and cell location the table pulls into. The tables are always on the same tab in the powerpoint.

    I found a bunch of info on pulling excel into powerpoint, but not the other way around. Is this even possible?

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: VBA to Pull an image from PPT into Excel as an enhanced metaframe picture

    a lot will depend on how your tables are stored and where you want them to go, but this might get you started
    it copies every table in the active powerpoint presentation into the active cell in excel, moving down 12 rows each time so they are not copied on top of each other (assuming your powerpoint tables have less than 12 rows)

    In the VBA screen in excel ensure tools > references > microsoft powerpoint object library is checked, or Excel wont be able to run PowerPoint macros

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-19-2017
    Location
    NYC
    MS-Off Ver
    2016
    Posts
    10

    Re: VBA to Pull an image from PPT into Excel as an enhanced metaframe picture

    @NickyC Thank you, is it possible to designate a specific slide number instead of every ppt slide?

    for example here, not sure what the correct identification for a slide would be.

    Please Login or Register  to view this content.

  4. #4
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: VBA to Pull an image from PPT into Excel as an enhanced metaframe picture

    yes, there are several ways to do that
    in the example below I have created an array containing the numbers of the slides with tables to import

    Please Login or Register  to view this content.

+ 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. Array to Image/Picture in Excel 64 bit
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-04-2016, 07:19 PM
  2. Replies: 5
    Last Post: 01-12-2015, 02:42 PM
  3. Copy an Image from a User form Picture Box to Worksheet Picture Box
    By sledgehammer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2014, 11:39 AM
  4. [SOLVED] VBA Macro to Copy from Excel and Paste Special Picture (Enhanced Metafile) in Outlook
    By Webman1012 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-19-2013, 11:19 AM
  5. Excel 2007 VBA Copy Range EXcluding Picture/Image
    By Hudas in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2012, 12:20 AM
  6. Copy Excel Data as Enhanced Metafile(Picture) to PowerPoint
    By pr4t3ek in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-06-2008, 07:34 AM
  7. Replies: 0
    Last Post: 04-01-2005, 02:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1