+ Reply to Thread
Results 1 to 14 of 14

MAcro to paste excel table into PPT slide automatically

  1. #1
    Registered User
    Join Date
    05-07-2012
    Location
    pune
    MS-Off Ver
    Excel 2007
    Posts
    57

    MAcro to paste excel table into PPT slide automatically

    Hello GUys,

    Need help on macro. I am attaching sample file.
    I want the data and table in the excel sheet to be pasted in PPT slide automatically.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: MAcro to paste excel table into PPT slide automatically

    So powerpoint macros are not as easy to find compared to excel.

    http://peltiertech.com/Excel/XL_PPT.html
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    05-07-2012
    Location
    pune
    MS-Off Ver
    Excel 2007
    Posts
    57

    Re: MAcro to paste excel table into PPT slide automatically

    Thanks for the link.

    But I am very New to Macro. so can you please write the code in my attached sheet and send me the updated sheet that will be very helpfull for me thanks a lot

    Regards
    Sam

  4. #4
    Forum Contributor geliedee's Avatar
    Join Date
    10-14-2013
    Location
    Manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    393

    Re: MAcro to paste excel table into PPT slide automatically

    Hi sameru,

    See this file. Hope it could help you.

    i divided it to 3 slides because having them in one slide is kinda crowded.

    Attached Files Attached Files

  5. #5
    Forum Contributor geliedee's Avatar
    Join Date
    10-14-2013
    Location
    Manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    393

    Re: MAcro to paste excel table into PPT slide automatically

    Enable content first, then click the buttons one by one.
    They will all go to one power point slides. :D

  6. #6
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: MAcro to paste excel table into PPT slide automatically

    Can you post the code in here?

  7. #7
    Registered User
    Join Date
    05-07-2012
    Location
    pune
    MS-Off Ver
    Excel 2007
    Posts
    57

    Re: MAcro to paste excel table into PPT slide automatically

    Thanks A lot its really help full.
    How can i view the code and if it is poosible to make it in one cilck. As I want the whole table in one slide

    Regards
    Sam

  8. #8
    Forum Contributor geliedee's Avatar
    Join Date
    10-14-2013
    Location
    Manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    393

    Re: MAcro to paste excel table into PPT slide automatically

    Hi Sameeru,

    You can click ALT + F11 to view the codes

    If you wish to change the columns to be exported in PPt, you can just simply change the range. You can see it in the codes! :D

  9. #9
    Forum Contributor geliedee's Avatar
    Join Date
    10-14-2013
    Location
    Manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    393

    Re: MAcro to paste excel table into PPT slide automatically

    Anyway, if you want to view it in one slide,
    it will be very small and not advisable. But you can try just change the range.

  10. #10
    Registered User
    Join Date
    05-07-2012
    Location
    pune
    MS-Off Ver
    Excel 2007
    Posts
    57

    Re: MAcro to paste excel table into PPT slide automatically

    Sorry Im not able to see the code its coming blank and asking some password after pressing ATL + F11

  11. #11
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: MAcro to paste excel table into PPT slide automatically

    The code is password protected.

    Can you simply paste it in here anyway so I can view it on my phone?

  12. #12
    Forum Contributor geliedee's Avatar
    Join Date
    10-14-2013
    Location
    Manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    393

    Re: MAcro to paste excel table into PPT slide automatically

    Hi MikeTron and Sameeru,

    this file is unprotected.

    or you can use this code.

    CreatePPT - Button 1
    CreatePPT2 -Button 2
    CreatePPT3- Button 3

    Please Login or Register  to view this content.
    Attached Files Attached Files

  13. #13
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: MAcro to paste excel table into PPT slide automatically

    Hey,

    So I am getting an error with the following line of code (with the bold portion):
    Set PPSlide = PPApp.ActivePresentation.Slides.Add(PPApp.ActivePresentation.Slides.Count + 1, ppLayoutBlank)

    What am I missing?

  14. #14
    Forum Contributor geliedee's Avatar
    Join Date
    10-14-2013
    Location
    Manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    393

    Re: MAcro to paste excel table into PPT slide automatically

    Hi MikeTron,

    did you click "Microsoft powerpoint 12.0 Object Library" on the references? References - VBAProject.jpg

+ 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. Copy and paste some charts from excel into specific slide on a powerpoint template
    By ones4rus in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2013, 03:00 AM
  2. macro to copy paste excel name range to powerpoint new slide
    By koi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-17-2013, 04:55 PM
  3. Paste multiple ranges by Inputbox and paste it on one slide in powerpoint
    By irfanparbatani in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-16-2012, 10:32 PM
  4. Replies: 1
    Last Post: 04-02-2012, 03:57 PM
  5. Select active slide by slide number in existing ppt through excel vba
    By amid in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-09-2009, 03:59 PM

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