+ Reply to Thread
Results 1 to 3 of 3

Add slide in Powerpoint via Excel

  1. #1
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,142

    Add slide in Powerpoint via Excel

    hi guys. via excel, i open a powerpoint template inside my com (named PptTemplate.pptx) and transfer the values of column A & B to the slides. this is my current code:
    Please Login or Register  to view this content.
    my question is how do i add slides based on the variable rows in my excel file? the slides must also be of the same design of my current slides. tried the code below but i got an error run-time error 429

  2. #2
    Forum Guru
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Add slide in Powerpoint via Excel

    Hi benishiryo,

    Thanks for all the help your posts have given me over the years. I didn't try your code. I modified existing code that I had.

    Try the following Macro which:
    a. Opens the PowerPoint file.
    b. Puts Text in the first 2 TextBoxes of Existing Slides until data runs out.
    c. If there are not enough slides, the last slide is duplicated as required.
    d. If there are too many slides, the extras are deleted.
    e. Saves and closes the PowerPoint file.


    Please Login or Register  to view this content.
    Lewis

    The following added Nov 25, 2015:
    For anyone wanting to try this out with minimal effort, I am adding the following files in the .zip file attachment:
    a. ExcelForumPutTextInPowerPointSlides.xls
    b. ExcelForumPutTextInPowerPointSlides.ppt


    Links to PowerPoint automation references:
    http://www.globaliconnect.com/excel/...=79&Itemid=475
    http://www.mahipalreddy.com/vba/ppvba.htm
    http://peltiertech.com/Excel/XL_PPT.html
    Attached Files Attached Files
    Last edited by LJMetzger; 11-25-2015 at 06:36 AM. Reason: Added note after signature and added sample files and links to references

  3. #3
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,142

    Re: Add slide in Powerpoint via Excel

    hi LJMetzger. glad to know that my posts have helped you before~ and now you are helping me! was initially worried i wouldn't understand from your code since you didn't add on to mine, but the comments you placed inside were extremely helpful. works brilliantly. thank you!
    =)

+ 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 2007 VBA code to close powerpoint slide show, but not powerpoint application
    By christopher@groth.cc in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-18-2015, 06:39 AM
  2. two excel charts per powerpoint slide
    By stubyh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-09-2013, 11:09 AM
  3. Adding a Powerpoint slide using Excel vba
    By db1966 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-25-2008, 12:07 PM
  4. [SOLVED] how to convert excel worksheet to a powerpoint slide
    By awcrutch in forum Excel General
    Replies: 2
    Last Post: 07-27-2006, 12:50 PM
  5. [SOLVED] VBA: Excel sheet to Powerpoint slide
    By Herve in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-08-2005, 12:10 PM
  6. Replies: 1
    Last Post: 06-29-2005, 03:05 PM
  7. [SOLVED] A way to convert Excel worksheet into Powerpoint slide
    By juzion in forum Excel General
    Replies: 1
    Last Post: 06-08-2005, 11:05 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