We help IT Professionals succeed at work.

variable objects in Powerpoint

jl conne
jl conne asked
on
1,140 Views
Last Modified: 2020-11-13
I have a master Powerpoint document that I use as a template with which to create new reports; changing keywords in title headings, table content and images specific to each project.   Format stays the same.
If my project-specific content is coming from either a field/cell in an excel document or is an image such as a png file, is there a way I can use variables within the Powerpoint template to refer to local files (png images) or a local excel file (a cell within excel), so that the Powerpoint for each report auto-loads and displays the content from these sources?
Comment
Watch Question

Jamie Garroch (MVP)PowerPoint Technical Consultant
CERTIFIED EXPERT

Commented:
You can do all sorts of clever stuff with VBA code in PowerPoint but before delving into that, are you looking for a programming answer?

Author

Commented:
Hi Jamie, I'm looking for any way to automate the content load.  It's all manual editing as is.  I have simple ppt slides with a heading text box, and an image or a table.  I want a word like a project name in the text box or the content of a field in a table to get its displayed value from a specific cell (ideally a variable name assigned to a cell) in an Excel file.  I want the image to display a specific local png file.  I can't find a way to do this using objects and don't know if VB can be used for this.
PowerPoint Technical Consultant
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION