-
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!
-
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
-
Forum Rules