+ Reply to Thread
Results 1 to 1 of 1

Update pptx file with data from excel file

  1. #1
    Registered User
    Join Date
    05-15-2020
    Location
    greece
    MS-Off Ver
    microsoft 365 business
    Posts
    1

    Unhappy Update pptx file with data from excel file

    Hello All,

    I would like to request your help in regards to the below:

    I have an pptx report with a standard format. It's include some data in a text box and charts that should be extracted and updated from an excel file each time when I am opening the pptx file.

    In other words I would like to set up for each slide to take the value from cell B2 sheet1 /for example/ and update the value in text box 1 in slide 2, next take the value from the C2 sheet 2 from the excel file and update the tex box 2 in the in the slide 2. and etc.
    Also, link the range ("A1:G3") of the sheet 4 to the chart on slide 4 and update the values when the pptx is opened

    All the action should be configured in the pptx VBA not from the excel file, as the excel file will be automated exported each time.

    I will really appropriate if somebody can help me.

    thank you very very much in advance for your time.

    Valentina
    Last edited by Valentina Serefidou; 05-15-2020 at 05:20 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. Edit chart size after copied from excel to PPTX file
    By hadoan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2019, 04:41 AM
  2. VBA to open a file, update/refresh all data and close file?
    By brianjluke in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-29-2013, 02:27 PM
  3. Replies: 0
    Last Post: 03-04-2013, 03:40 AM
  4. Auto update Master File from the Data entry File.
    By Saintjp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-08-2013, 05:19 PM
  5. Auto update Master File from the Data entry File.
    By Saintjp in forum Excel General
    Replies: 1
    Last Post: 02-07-2013, 05:51 PM
  6. Update cell links between 2 excel file without opening source file
    By ferry in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-26-2012, 03:03 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