+ Reply to Thread
Results 1 to 3 of 3

Export Excel table to Powerpoint

  1. #1
    Registered User
    Join Date
    07-15-2017
    Location
    Switzerland
    MS-Off Ver
    MS 10
    Posts
    16

    Export Excel table to Powerpoint

    Hi all

    Could you please help me with something?
    I try to export an table in Excel into Powerpoint to create an presentation easily.
    The code works when I execute step by step but not when I press F5…

    The problem is that I insert a new slide and then I want to paste the first table. When running it does not execute this properly (I believe that the myShape is not correctly defined…)

    Thanks and Regards,
    Flo

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor Sean Thomas's Avatar
    Join Date
    03-25-2012
    Location
    HerneBay, Kent, UK
    MS-Off Ver
    Excel 2007,2016
    Posts
    971

    Re: Export Excel table to Powerpoint

    Its a bit difficult without seeing the workbook & powerpoint.
    However you add a slide - ppLayoutEmpty
    then you are assigning a shape based on finding the shape on that slide.
    Only thing is if its an empty slide then there are no shapes to count and therefore your code will error as its got no shape to use

    try debug.print myslide.shapes.count before the line that errors and see if it returns a value
    Regards
    Sean

    Please add to my reputation if you think i helped
    (click on the star below the post)
    Mark threads as "Solved" if you have your answer
    (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code:
    [code] Your code here [code]
    Please supply a workbook containing example Data:
    It makes its easier to answer your problem & saves time!

  3. #3
    Valued Forum Contributor Maudibe's Avatar
    Join Date
    12-21-2016
    Location
    USA
    MS-Off Ver
    2010-2013
    Posts
    326

    Re: Export Excel table to Powerpoint

    Take a look here:

    https://www.excelforum.com/excel-pro...ml#post4753988

+ 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. Export Excel Area to PowerPoint
    By brisardo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-26-2017, 04:06 AM
  2. Export from Excel to powerpoint using VBA
    By mayoorsubbu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-31-2015, 10:19 AM
  3. [SOLVED] Extract Table from a Spreadsheet, arrange in various tabs and export to PowerPoint
    By vnzerem in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-27-2015, 08:11 PM
  4. Trying to export results from a PowerPoint quiz to Excel
    By DPWM in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-09-2013, 01:54 PM
  5. Export data from Excel to PowerPoint
    By nalfin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-01-2009, 09:46 AM
  6. Excel to Powerpoint export
    By webbug08 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-05-2009, 09:41 AM
  7. Export Excel data to Word and PowerPoint
    By racudd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-27-2007, 11:30 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