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.

Attached Files

	SlideShowPresentation.pptm (130.8 KB, 2 views)
	SlideShowDatabase.xlsx (9.2 KB, 2 views)

I have not looked at your files because sharing macros across files can be scary. However. I know that if you are changing anything with VBA to a PowerPoint slide in presentation mode. It will not update. You need to do the Goto slide in order to "refresh" it.
If you share your code I can take a look at it and give more details if needed.