+ Reply to Thread
Results 1 to 2 of 2

Excel data in powerpoint automation

  1. #1
    Registered User
    Join Date
    08-12-2021
    Location
    India
    MS-Off Ver
    2019
    Posts
    3

    Excel data in powerpoint automation

    Hi,
    I have been stuck trying to find a way to do this, but not able to find anything.

    So, I have an excel file with columns and multiple rows. So each column is for represents a particular data and each row is for a different client with a different client name. I have a PowerPoint file template with just 1 slide. In that 1 slide, there is the name of a client, then a few paragraphs about what they do and also data in form of numbers. So this is just for 1 client.
    What I want to do is, create multiple 1 page PowerPoint presentations for each client from the excel file I have. The PowerPoint slide will have the same paragraphs and logos, but only the data should change depending on each row of the excel. So, I want to create 1000 ppt slides for each row (representing each client) from that excel file.

    Is this possible anyway? have heard that it can be done using VBA, but I don't know how to do it. Any help would be appreciated.

  2. #2
    Forum Contributor
    Join Date
    04-15-2013
    Location
    Singapore, Melbourne
    MS-Off Ver
    Office 365
    Posts
    167

    Re: Excel data in powerpoint automation

    Do you have tried Mail Merge?
    Row row row your boat
    Gently down the stream

+ 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. Replies: 0
    Last Post: 01-06-2017, 07:08 AM
  2. Replies: 0
    Last Post: 08-23-2016, 09:43 AM
  3. Replies: 1
    Last Post: 06-09-2016, 12:05 PM
  4. Replies: 6
    Last Post: 08-18-2015, 06:39 AM
  5. Excel/PowerPoint VBA teaser: How to change data labels in PowerPoint chart by VBA?
    By lukelucky in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-12-2015, 11:47 AM
  6. Excel Powerpoint Automation Run time Error
    By sjunak in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-30-2014, 04:03 AM
  7. 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

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