+ Reply to Thread
Results 1 to 2 of 2

VBA Transfer Range from Excel to Powerpoint (New or Existing Powerpoint Presentation)

  1. #1
    Registered User
    Join Date
    11-04-2008
    Location
    England
    Posts
    14

    VBA Transfer Range from Excel to Powerpoint (New or Existing Powerpoint Presentation)

    Hi everyone,

    First post on this helpful forum, so please accept my apologies if my request is not in a helpful format however my request is as follows:

    I have two tabs within my spread sheet (attached) which are called Sheet A and Sheet B. They both have the same VBA button function that will transfer the selected ranges (Area 1 and Area 2) to there own PowerPoint slides in bitmap format.

    However I would prefer once the PowerPoint is open in the first instance when I run the function (lets say within Sheet A) that when I run the VBA in Sheet B it will just make the additional slides to the existing PowerPoint rather than opening it's own separate PowerPoint application for each sheet.

    I have found an existing example of VBA that identifies if PowerPoint is open then it will add the existing set of slides in the following link: http://www.vbaexpress.com/kb/getarticle.php?kb_id=370, however I cannot seem to incorporate it into the VBA within my spread sheet.

    Please can anyone assist in solving my preference?

    Cheers everyone
    Attached Files Attached Files

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,121

    Re: VBA Transfer Range from Excel to Powerpoint (New or Existing Powerpoint Presentation)

    See if this will get you close.
    Please Login or Register  to view this content.
    David
    (*) Reputation points appreciated.

+ 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. Excel chart in powerpoint presentation
    By beneesetas14 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-08-2014, 06:53 AM
  2. Replies: 13
    Last Post: 01-11-2013, 04:46 PM
  3. Populating a powerpoint presentation from an excel database
    By My_Pretty_Heels in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-08-2012, 04:47 AM
  4. PowerPoint Presentation in Excel
    By mehare in forum Excel General
    Replies: 1
    Last Post: 09-01-2006, 11:56 AM
  5. Printing an Eembedded powerpoint presentation from Excel
    By Mayank Prakash Gupta in forum Excel General
    Replies: 0
    Last Post: 11-18-2005, 01:10 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