+ Reply to Thread
Results 1 to 3 of 3

Copying from Excel Workbook to Open Powerpoint

  1. #1
    Registered User
    Join Date
    01-14-2021
    Location
    New York
    MS-Off Ver
    2020
    Posts
    2

    Copying from Excel Workbook to Open Powerpoint

    Hello,

    I am trying to achieve something very specific. I would like to write a macro that copies a range of cells in my workbook, then goes to a PowerPoint presentation that will be already open, the name of which is referenced in a cell on a different tab in the workbook, and then creates a new blank slide and pastes those cells as an enhanced metafile picture.

    I cant seem to find anywhere a way to "activate" a powerpoint that already exists, the name of which is in the excel workbook.

    Any help greatly appreciated.

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,719

    Re: Copying from Excel Workbook to Open Powerpoint

    https://www.thespreadsheetguru.com/b...point-with-vba

  3. #3
    Registered User
    Join Date
    01-14-2021
    Location
    New York
    MS-Off Ver
    2020
    Posts
    2

    Re: Copying from Excel Workbook to Open Powerpoint

    I saw this except this creates a new powerpoint. What I am looking for for takes the range I want copied, then creates a new slide in a PowerPoint that already is in existence and is open, and pastes it.
    For example:
    I have a PowerPoint presentation I have been working on with many slides already.
    I have an excel workbook with information that I need to tailor but once it is done I want in the above presentation on a new slide.
    Every time I run the macro I want it to take that same range, create a new slide in the existing open PowerPoint presentation and paste the data

    To be clear I don't want the macro to open a closed presentation, or create a new presentation I just need it to find the one I have open and am working in.

+ 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. Copying Excel to Powerpoint VBA
    By iffitheking in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-24-2019, 09:48 PM
  2. Replies: 1
    Last Post: 06-09-2016, 12:05 PM
  3. Need to change VBA code from creating new PowerPoint to open an existing PowerPoint
    By bmchenry3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2015, 12:14 AM
  4. [SOLVED] open a new Workbook from Powerpoint VBA edit
    By mortphil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-09-2014, 07:29 AM
  5. [SOLVED] Copying data from a closed workbook into an open workbook ignoring excel filter?
    By reach78 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 09-17-2013, 12:31 AM
  6. Replies: 13
    Last Post: 01-11-2013, 04:46 PM
  7. [SOLVED] Copying worksheet from another open workbook using variables, paste to active workbook
    By sanpedro_nz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-08-2012, 08:25 AM

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