Consulting

Results 1 to 5 of 5

Thread: Gluing/connecting connectors to shapes in PowerPoint using VBA

  1. #1

    Gluing/connecting connectors to shapes in PowerPoint using VBA

    Hello,

    I am hustling to find a way where I can glue or stick connectors to shapes. Which can also be said like, changing dynamic connectors to static connectors.So that when a shape is moved connectors stick to that shape and adjust accordingly. Please help

    I did lot of research was unable to find a way. Many solutions were on visio which I am not using.

    This is the case I am trying to achieve, but by uisng VBA:
    https://www.indezine.com/products/po...or-points.html

    Thought this would help us to start:
    https://stackoverflow.com/questions/...dshape-vba-ppt
    https://docs.microsoft.com/en-us/pre...ectedfrom=MSDN

    I am working on it as well, if I find a solution I will update the feed. Thank you.

  2. #2
    VBAX Wizard
    Joined
    Apr 2007
    Posts
    6,950
    Location
    May be possible, but probably not worth the effort to make a flexible solution in VBA

    I always just do it with the mouse

    I've also put my 'special' shapes after formatting (color, border, text, anchor points, etc.) on slides in a 'library' presentation and copy/pasted as needed


    Capture.JPG
    Attached Files Attached Files
    Paul

    ------------------------------------------------------------------------------------------------------------------------
    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)
    (multiple files can be selected while holding Ctrl key) / 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
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  3. #3
    Hello Paul,

    Thanks for the insights. Assuming there were already many connectors between boxes in a slide, running a macro which sets these connectors to stick with boxes. Can we solve this in any way? As shown in picture, the connector is not actually connected to shape displaying grey connection points instead of green connection points.
    Quote Originally Posted by Paul_Hossler View Post
    May be possible, but probably not worth the effort to make a flexible solution in VBA

    I always just do it with the mouse

    I've also put my 'special' shapes after formatting (color, border, text, anchor points, etc.) on slides in a 'library' presentation and copy/pasted as needed


    Capture.JPG
    Attached Images Attached Images

  4. #4
    VBAX Wizard
    Joined
    Apr 2007
    Posts
    6,950
    Location
    There MIGHT be a way to do it, but it's w..a..y beyond my PP abilities

    Also, I'm moving this to the PP forum since you might get more people looking at it there
    Paul

    ------------------------------------------------------------------------------------------------------------------------
    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)
    (multiple files can be selected while holding Ctrl key) / 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
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  5. #5
    with ray of hope..
    Thanks Paul

Posting Permissions

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