Consulting

Results 1 to 4 of 4

Thread: Pulling text from Excel, multiple images on a slide, for a number of slides

  1. #1
    VBAX Newbie
    Joined
    Sep 2018
    Posts
    2
    Location

    Pulling text from Excel, multiple images on a slide, for a number of slides

    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/...c-f21e22be8851


    Thanks so much
    Last edited by Reece; 09-04-2018 at 07:11 AM.

  2. #2
    VBAX Master
    Joined
    Feb 2007
    Posts
    1,686
    Location
    Please do not cross post (post on multiple forums without at least making this clear.) It's a sure way to stop people helping.
    https://answers.microsoft.com/en-us/...c-f21e22be8851
    John Wilson
    Microsoft PowerPoint MVP
    Amazing Free PowerPoint Tutorials
    http://www.pptalchemy.co.uk/powerpoi...tutorials.html

  3. #3
    VBAX Newbie
    Joined
    Sep 2018
    Posts
    2
    Location
    Sorry John - I was not aware the forums were associated and the same people would be viewing them. I have some responses on the other, and will delete this one. Thanks for the heads up! If I mark it as solved, will it delete this thread? I am not sure how to delete it otherwise

    Reece

  4. #4
    VBAX Master
    Joined
    Feb 2007
    Posts
    1,686
    Location
    You just need to say that it is cross posted AND if you get a solution elsewhere go to all the posts and say so!
    John Wilson
    Microsoft PowerPoint MVP
    Amazing Free PowerPoint Tutorials
    http://www.pptalchemy.co.uk/powerpoi...tutorials.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •