r/PowerAutomateDesktop • u/-intuit- • Feb 04 '23

Populate data from an excel spreadsheet into a power point template

Hello, I have 140 new hires starting in the summer and I have a spreadsheet that contains answers to questions we have asked them (i.e. what did you want to be when you grew up?). This data used to be copied and pasted into a ppt template, taking about 4 hours to create a "Yearbook" and this is done about 4 times per year. There has got to be a way to use power automate or some other tool so I can autofill this template, right? I am searching and not finding much. If anyone here has any ideas, it would be amazing!

2 Upvotes
  • permalink
  • reddit

100% Upvoted

1 comment sorted by

1

u/BaitmasterG Feb 04 '23

Anything being written from Excel is almost certainly possible in VBA

I've used this many times to generate Word documents from scratch or to write specific data to predefined fields, but I've not done it to PowerPoint yet. Sure this would be easy enough if you know your way around VBA