Results 1 to 3 of 3

Thread: Advice Needed: PPT Workflow Automation

  1. #1
    VBAX Regular
    Apr 2017

    Question Advice Needed: PPT Workflow Automation

    I am looking for advice. I have about 80 PPT workflows. Each is slightly different. When I need to update a universal piece, well, I have to update 80 PPTs.

    Question: Is it possible to automate updating text inside of shapes using Excel? Sort of like a mail merge.

    Over the past 3 months, I have researched solutions but can't find something on a larger scale that will accomplish my task.

    I'm just looking for advice, and I can start researching based on your advice. Thank you.

  2. #2
    VBAX Sage
    Apr 2007
    United States
    Without knowing what at least one of the 80 looks like, this is a guess

    I'd Use PP instead of Excel

    Use Dir() to loop through the 80

    Maybe have to loop through the slides in each PP

    Maybe look through the textboxes on each slide to find the one to dhange

    Change it

    Save the PP

    On to next


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums

  3. #3
    VBAX Regular
    Apr 2017
    Great, thank you.

Tags for this Thread

Posting Permissions

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