+ Reply to Thread
Results 1 to 4 of 4

Need to change VBA code from creating new PowerPoint to open an existing PowerPoint

  1. #1
    Registered User
    Join Date
    07-27-2015
    Location
    Dallas, TX
    MS-Off Ver
    Microsoft Office 7
    Posts
    2

    Need to change VBA code from creating new PowerPoint to open an existing PowerPoint

    I have an Excel document that I need to paste into PowerPoint. I found this VBA code online and it works great. My only issue is it creates a new PowerPoint presentation every time it runs. Instead, I would like the code to insert the slide into an existing file I created. Any help would be greatly appreciated. Thanks!

    Please Login or Register  to view this content.

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

    Re: Need to change VBA code from creating new PowerPoint to open an existing PowerPoint

    Hi
    you need to open the file. Put the name of the file in the place of "C:\My Documents\My Presentation.pptx" below


    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-27-2015
    Location
    Dallas, TX
    MS-Off Ver
    Microsoft Office 7
    Posts
    2

    Re: Need to change VBA code from creating new PowerPoint to open an existing PowerPoint

    Thank you! I am still getting hung up at this line:

    Please Login or Register  to view this content.
    Any thoughts?

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

    Re: Need to change VBA code from creating new PowerPoint to open an existing PowerPoint

    Hi
    I'm getting problems with the paste command for some reason but I think your problem may be that you can only select an object in the active slide.

    Try inserting PPSlide.Select in the row above PPSlide.Shapes(1).Select

+ 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/PowerPoint VBA teaser: How to change data labels in PowerPoint chart by VBA?
    By lukelucky in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-12-2015, 11:47 AM
  2. 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
  3. VBA userform for choosing colors: change Excel code to work for powerpoint?
    By submariner18 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-22-2013, 05:49 PM
  4. PowerPoint interop without showing the PowerPoint application window
    By philippjb0 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-21-2013, 06:36 AM
  5. Replies: 13
    Last Post: 01-11-2013, 04:46 PM
  6. VBA Code to export Excel to OVERWRITE an EXISTING PowerPoint
    By rick_tiger in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-06-2012, 04:49 AM
  7. Open Powerpoint Presentation via Excel VBA code
    By hurlbut777 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-05-2010, 06:47 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