"Slide Show" with data from excel.
I am trying to build a slide show in PowerPoint that will take data from a spreadsheet in excel, and I'm not quite sure where to start. Its not really a slide show, but a macro that will change a picture every 30 seconds.
I have a spreadsheet with data including:
Image Name (title of the jpeg file)
Subject Name (Name of the person in the picture)
Caption (caption for the photo)
Location (where the photo is saved on the computer)
I also have a PowerPoint presentation with a picture titled "Photo" and 3 shapes titled "Image Name", "Subject Name" & "Caption"
I would like to have a macro that I can run that will change the "Photo" picture to a photo from my spreadsheet and change the text of the shapes to the appropriate image name, subject name and caption. I would like the photo to change every 30 seconds.
The photos are not saved in the excel or power point files. They are saved on the computer and the address to where the file is saved in in the spreadsheet.
Any help would be very appreciated.
|