+ Reply to Thread
Results 1 to 4 of 4

VBA to copy Excel in to PowerPoint, with flexible slide numbers

  1. #1
    Forum Contributor
    Join Date
    12-13-2012
    Location
    Shropshire, England
    MS-Off Ver
    Excel 2007 /10 /13
    Posts
    118

    VBA to copy Excel in to PowerPoint, with flexible slide numbers

    Hi all

    I have some VBA that I've pinched/adapted to copy certain ranges from excel and paste into a PowerPoint presentation, based on me knowing the slide numbers required for them to go into.

    A section shown below

    Please Login or Register  to view this content.
    BUT, I would like to know if there's any way of "tagging" the slides in PP somehow, so that I don't need to specifically name the slide numbers in VBA (shown as (5) in above code) and have some kind of reference instead?

    Long shot I know, but maybe someone has thought of this before...

    thanks as always

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: VBA to copy Excel in to PowerPoint, with flexible slide numbers

    The following is an extract of code that I use. You might be able to adapt it to your use. I have a number of ranges and charts that I need to copy to multiple places in a powerpoint presentation. I do this by setting up a "map" of what goes where in an Excel table. The code itself has some additional stuff about updating some text on the slide. The part of interest starts with ' Add objects.

    In the spreadsheet:
    Column A is the spreadsheet page that contains the object
    Column B is the name of the object or range
    Column C is the type (Chart or range)
    Column D is the page in the powerpoint presentation where the chart or range will be pasted.
    Column E is not used in the code. It's for people to read.
    Column F:I are the coordinates and size of the object.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Forum Contributor
    Join Date
    12-13-2012
    Location
    Shropshire, England
    MS-Off Ver
    Excel 2007 /10 /13
    Posts
    118

    Re: VBA to copy Excel in to PowerPoint, with flexible slide numbers

    thanks for that, can't see any VBA there though, just the excel table.
    Not sure this is quite what I'm looking for though, as ideally I want the code to look at the PowerPoint to identify the slides needed, as sometimes we add or remove slides inbetween the ones we paste into.
    Would be interested to see your code though, to see if I can improve what I already have

    thanks again

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: VBA to copy Excel in to PowerPoint, with flexible slide numbers

    Alt-F11 brings it up just fine for me.
    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. Need to Copy Excel print_area page to PowerPoint with PrintTitleRows on each slide
    By Hildegard$1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2015, 09:46 AM
  2. [SOLVED] How to copy and paste 4 excel graphs into a single PowerPoint slide evenly?
    By Mirisage in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 03-07-2015, 12:47 AM
  3. Script to copy excel table in to a powerpoint slide
    By Robert110 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-03-2014, 06:15 PM
  4. Copy and paste some charts from excel into specific slide on a powerpoint template
    By ones4rus in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2013, 03:00 AM
  5. macro to copy paste excel name range to powerpoint new slide
    By koi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-17-2013, 04:55 PM
  6. [SOLVED] Copy Named charts in Excel to specific slide in Powerpoint
    By allstarrunner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2012, 09:10 AM
  7. Copy Range from Excel to Powerpoint Slide
    By cricrazy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-17-2009, 07:11 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