+ Reply to Thread
Results 1 to 1 of 1

Update data from excel to powerpoint using VBA

  1. #1
    Registered User
    Join Date
    10-12-2019
    Location
    india
    MS-Off Ver
    16
    Posts
    49

    Update data from excel to powerpoint using VBA

    I hope this is a super simple question but for some reason i cant figure it out.
    My requirement: Update data from excel to powerpoint.
    I have many shapes in powerpoint slide (for better understand see image ppt.png) like Rectangle 1,Rectangle 5,Rectangle 3,
    Rectangle 9,Rectangle 8,Rectangle 6 so on & Pentagon 1,Pentagon 5,Pentagon 3,
    Pentagon 4,Pentagon 55,Pentagon 6 ...... which contains some text &
    Graphic shape(Graphic 8,Graphic 7,Graphic 12,Graphic 5,Graphic 9)contains image.
    I want to change/updates all text in shapes(Rectangle/Pentagon) & change images
    in Graphic shape(Graphic 8,Graphic 7,Graphic 12,Graphic 5,Graphic 9) also.

    For example:I want to change
    see image:ppt.png

    Shape(Pentagon 5) text ie "1 in 11" to "5 in 100";
    Shape(Rectangle 3) text ie "Netflix" to "Hullu";
    Shape(Graphic 12) image ie "Netflix.png" to "Hullu.png";

    I have this type set [Shape(Pentagon 5)+Shape(Rectangle 3)+Shape(Graphic 12)] more than 30 ie
    30X3=90 elements.Its very hard to update in powerpoint everytime.
    NOTE:all shape has animation so I want any replace type command (mainly for image)
    otherwise animation may be lost.

    So I want to configure any micro/vba in excel(from where all data) that updates data in powerpoint.
    May be it will be done by some array consept but cannot configure.
    Attached Images Attached Images
    Last edited by dibyendu2280; 08-21-2020 at 03:04 AM.

+ 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. PowerPoint live update excel data during slide show
    By Tyger0951 in forum PowerPoint Formatting & General
    Replies: 8
    Last Post: 10-15-2019, 10:38 AM
  2. Replies: 0
    Last Post: 08-23-2016, 09:43 AM
  3. Replies: 1
    Last Post: 06-09-2016, 12:05 PM
  4. PowerPoint live update excel data during slide show
    By Tyger0951 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2014, 02:51 AM
  5. [SOLVED] Trying to update Excel data from PowerPoint that is NOT linked.
    By DPWM in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-25-2013, 07:18 PM
  6. Replies: 2
    Last Post: 06-16-2013, 02:58 PM
  7. How to dynamically update links based on data (not Cells) in PowerPoint via Excel?
    By pats2kdynasty in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-25-2012, 01:10 PM

Tags for this Thread

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