Avatar of jl conne
jl conne

asked on 

variable objects in Powerpoint

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?
Microsoft PowerPoint

Avatar of undefined
Last Comment
Jamie Garroch (MVP)
Avatar of Jamie Garroch (MVP)
Jamie Garroch (MVP)
Flag of United Kingdom of Great Britain and Northern Ireland image

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?
Avatar of jl conne
jl conne

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of Jamie Garroch (MVP)
Jamie Garroch (MVP)
Flag of United Kingdom of Great Britain and Northern Ireland image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Microsoft PowerPoint
Microsoft PowerPoint

PowerPoint is a slide show presentation program currently developed by Microsoft. PowerPoint presentations consist of a number of individual pages or "slides" that may contain text, graphics, sound, movies, and other objects, which may be arranged freely. The presentation can be printed, displayed live on a computer, or navigated through at the command of the presenter. Slides can also form the basis of webcasts.

4K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo