+ Reply to Thread
Results 1 to 5 of 5

VBA code to copy range of table from Excel 2010 to (existing) ppt (looping through a list)

  1. #1
    Registered User
    Join Date
    01-09-2015
    Location
    Germany
    MS-Off Ver
    MS Office 2010
    Posts
    34

    VBA code to copy range of table from Excel 2010 to (existing) ppt (looping through a list)

    Good day/evening,
    I am searching for a simple VBA code which is doing the following (in the attached example):
    1/ Looping through the cell A1 of the sheet "Outputtable" (so first for Electricity, then for Nitrogen, etc.) and
    2/ Copying the corresponding data of the table range of A1:F3 to a powerpoint in separate slides (1 for Electricity, 1 for Nitrogen).
    3/ With "good" positioning to put comments below the table range.
    I am using Excel 2010, accordingly Power point.
    Thanks a lot for any support.
    Best regards
    Heinz
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    12-14-2012
    Location
    Czech Republic
    MS-Off Ver
    Excel 2010
    Posts
    92

    Re: VBA code to copy range of table from Excel 2010 to (existing) ppt (looping through a l

    Hello Heinz,

    try this code:
    Please Login or Register  to view this content.
    Make sure you have set reference to Microsoft PowerPoint Object Library. I'm sorry I could not find out how to upload the file.
    Will do later when I get how to..

    Regards,
    sysss

  3. #3
    Registered User
    Join Date
    12-14-2012
    Location
    Czech Republic
    MS-Off Ver
    Excel 2010
    Posts
    92

    Re: VBA code to copy range of table from Excel 2010 to (existing) ppt (looping through a l

    Hi again,

    now with the file.

    s.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    01-09-2015
    Location
    Germany
    MS-Off Ver
    MS Office 2010
    Posts
    34

    Re: VBA code to copy range of table from Excel 2010 to (existing) ppt (looping through a l

    Dear sysss,
    Perfect, many thanks, works very well. Great.
    Best regards
    Heinz

  5. #5
    Registered User
    Join Date
    12-14-2012
    Location
    Czech Republic
    MS-Off Ver
    Excel 2010
    Posts
    92

    Re: VBA code to copy range of table from Excel 2010 to (existing) ppt (looping through a l

    Hello Heinz,

    I'm really glad to help you.
    Please, If you're satisfied with the solution mark this thread as solved (tools in the top).
    And you can help me too .. so if you happy and your issue solved there is a little star on left...

    Thanks
    Have a nice day
    sysss

+ 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. update existing code to copy and KEEP existing data
    By scott micklo in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 01-26-2016, 05:41 PM
  2. [SOLVED] Copying Excel Range into existing MS Word Table
    By ericv101 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-27-2013, 06:25 PM
  3. [SOLVED] Select Existing WS from Range List + Copy + Rename from List
    By robegan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-06-2013, 10:56 PM
  4. [SOLVED] [EXCEL] Open and copy from workbook specified in existing cells / 2010 upgrade problem
    By morten.bay in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-27-2012, 04:20 AM
  5. [EXCEL] Open and copy from workbook specified in existing cells / 2010 upgrade problem
    By morten.bay in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-22-2012, 09:07 AM
  6. [SOLVED] How to convert existing Excel List into a table in Access?
    By anna in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-18-2006, 07:00 PM
  7. Data From Excel Range To Existing Access Table
    By Jason in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 12-02-2005, 05:14 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