Consulting

Results 1 to 2 of 2

Thread: Import data from excel to a label in powerpoint

  1. #1

    Import data from excel to a label in powerpoint

    I have this excel file that works as a data base, there i fill everyday 5 tables in 5 different worksheets, each table grows along with the day, so each row is linked to an specific date.

    Then i need to make a daily report in a powerpoint presentation. I've done the presentation as a template, putting images of the tables and then embedding labels in everyplace i need.

    Now the request, I need to do a vba program that take the value of one cell that is in the same row as some specific date (that i can define) and then put it in a label on a existing powerpoint presentation. After that i need that the these changes will be saved in a new file with the date as file name.
    I hope i explained myself clear enough because I'm not native English speaker.

    I'm using office 2003. All the help will be appreciated

    Thanks in advance!

  2. #2
    I would like to have a macro that when starts asks for the date that i want the report to linked to, then check it with the data within the excel file and after that send it to the respective powerpoint label.

    As a start it would be helpeful some code that can take one value from excel and then put it in a label embedded label on a powerppoint presentation. I think I can manage the rest, while i'm learning VBA.

    Thanks again.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •