Reece
09-04-2018, 05:18 AM
Hi there,
I am a complete beginner with VBA. I am attempting to learn the basics and then build off that knowledge to finish this task, but would appreciate any ideas that are shared here.
I am creating ~180 slides. Each of the slides will have identical layouts, and include the following components: A text box, of which the contents will be populated from Excel, and about 7 different images placed in specific places.
I know the basics of how to add a text box and how to add an image, however I am struggling with the following items
1. Populating text boxes from excel, ensuring the correct text goes onto the right slide
2. Adding multiple images to a slide, have them each be positioned in a set location, & how to get VBA to differentiate between each image such that it places the correct image in the correct spot
3. Doing this for each slide in the document, again ensuring the contents correspond to the correct slide.
Any advice / resources to look at would be greatly appreciated. Please let me know if the above is not clear enough or if I should elaborate.
Note: I have cross-posted this here: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_powerpoint-mso_other-mso_2010/looking-for-help-using-loops-and-other-advice-to/0da56497-d931-4656-8f0c-f21e22be8851
Thanks so much
I am a complete beginner with VBA. I am attempting to learn the basics and then build off that knowledge to finish this task, but would appreciate any ideas that are shared here.
I am creating ~180 slides. Each of the slides will have identical layouts, and include the following components: A text box, of which the contents will be populated from Excel, and about 7 different images placed in specific places.
I know the basics of how to add a text box and how to add an image, however I am struggling with the following items
1. Populating text boxes from excel, ensuring the correct text goes onto the right slide
2. Adding multiple images to a slide, have them each be positioned in a set location, & how to get VBA to differentiate between each image such that it places the correct image in the correct spot
3. Doing this for each slide in the document, again ensuring the contents correspond to the correct slide.
Any advice / resources to look at would be greatly appreciated. Please let me know if the above is not clear enough or if I should elaborate.
Note: I have cross-posted this here: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_powerpoint-mso_other-mso_2010/looking-for-help-using-loops-and-other-advice-to/0da56497-d931-4656-8f0c-f21e22be8851
Thanks so much