+ Reply to Thread
Results 1 to 4 of 4

Copying data from Excel to PowerPoint skips steps

  1. 08-07-2020, 09:31 AM #1
    Jstns
    Jstns is offline
    Registered User
    Join Date
    02-14-2017
    Location
    Hilversum, Netherlands
    MS-Off Ver
    2010
    Posts
    92

    Copying data from Excel to PowerPoint skips steps

    Hi everyone!

    I am using Excel VBA to copy and paste data to a PowerPoint presentation. The data copies titles, text and tables from Excel into PowerPoint. Ever since I have added more steps to it, for some reason it skips multiple steps. It does select the tables, but for some reason it does not update them. When I go through the code step by step with F8 it does work for some reason. Please help out!

    You can find the code here:

    Please Login or Register  to view this content.
    For some reason I cannot upload the PowerPoint, but it is a very simple PPT template with a title and 3 tables.

    Thank you for your help!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-07-2020, 09:52 AM #2
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Copying data from Excel to PowerPoint skips steps

    try zipping the ppt file in order to upload, or change the file extension in order to be an acceptable file type to the forum
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
  3. 08-07-2020, 09:56 AM #3
    Jstns
    Jstns is offline
    Registered User
    Join Date
    02-14-2017
    Location
    Hilversum, Netherlands
    MS-Off Ver
    2010
    Posts
    92

    Re: Copying data from Excel to PowerPoint skips steps

    Great tip! Please find it attached
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 08-07-2020, 12:28 PM #4
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Copying data from Excel to PowerPoint skips steps

    your code was working but only if you step through the code line by line. This suggests a timing issue with the code and powerpoint updating.

    When I automate ppt tables I write directly to the table, rather than rely on copy/paste.
    This code will write to table cells, adding rows or columns to ends if required.

    It also do it in a loop through the 3 data areas.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copying data from excel to Powerpoint
    By chrisellis250 in forum PowerPoint Formatting & General
    Replies: 1
    Last Post: 04-09-2019, 01:06 PM
  2. Copying data from Excel to PowerPoint as text or table
    By BillDoor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2016, 04:12 AM
  3. Data input in powerpoint to select data in excel and report back to powerpoint
    By daveybright in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2009, 09:54 PM
  4. Copying Data From Excel to a Powerpoint Presentation
    By Vishal Dsouza in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-27-2007, 10:54 AM
  5. Copying Data From Excel to a Powerpoint Presentation
    By Vishal Dsouza in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-27-2007, 08:48 AM
  6. copying data in steps
    By nmatia in forum Excel General
    Replies: 3
    Last Post: 04-21-2007, 10:31 AM
  7. [SOLVED] copying data from Powerpoint to Excel
    By DB in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-09-2005, 12:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1