+ Reply to Thread
Results 1 to 3 of 3

To paste range from Excel to existing slides in PowerPoint

  1. #1
    Forum Contributor
    Join Date
    09-19-2017
    Location
    London
    MS-Off Ver
    2015
    Posts
    169

    To paste range from Excel to existing slides in PowerPoint

    Hi!

    I have this one presentation slides which already has its content. My goal now is to paste new things from Excel to the same slides, instead of adding new slides to the PowerPoint file.

    Here is my code:

    Please Login or Register  to view this content.
    In this code, the range will be added to new slides, but instead I want the cell ranges to be pasted in existing slides inside an active PowerPoint. May I know how? May anyone assist me?

    Thank you in advance!

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: To paste range from Excel to existing slides in PowerPoint

    You are telling it to ADD a new slide here
    Please Login or Register  to view this content.
    So what you will have to do is add code to select a specific slide and avoid the .Add, maybe .Select
    You got this code from somewhere and have been using it so I imagine a little VBA knowledge must be available
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Contributor
    Join Date
    09-19-2017
    Location
    London
    MS-Off Ver
    2015
    Posts
    169

    Re: To paste range from Excel to existing slides in PowerPoint

    Quote Originally Posted by Keebellah View Post
    You are telling it to ADD a new slide here
    Please Login or Register  to view this content.
    So what you will have to do is add code to select a specific slide and avoid the .Add, maybe .Select
    You got this code from somewhere and have been using it so I imagine a little VBA knowledge must be available
    I have tried select and have tried to find other term to ensure the code allows the pasting action is to existing slides but I could not find any. Using select would give an error. I am new to VBA.

+ 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: 13
    Last Post: 10-12-2017, 08:46 PM
  2. Copy data from Excel to PowerPoint slides
    By RareNasturtium in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2016, 01:17 PM
  3. VBA Transfer Range from Excel to Powerpoint (New or Existing Powerpoint Presentation)
    By ThePeoplesClub in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2014, 02:52 PM
  4. VBA Copy Range from Excel to Powerpoint slides
    By stepet5618 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-17-2014, 04:32 AM
  5. Looping macro to paste Excel ranges to new Powerpoint slides
    By sammonite in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-06-2012, 05:18 AM
  6. Excel formulas on different Powerpoint Slides
    By liseladele in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-31-2006, 07:28 PM
  7. Generating, changing PowerPoint slides from Excel
    By p. panter in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-09-2006, 12:50 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