Change Links through VBA

Posted on 2007-07-30
Last Modified: 2012-06-21
Is there a way in VBA to change all the links?  I only need part of the link to be changed. For example if it's like this below, then the only portion I need changed is the NT User ID - ABC to something else but the rest, (especially the cell references should be the same.  And I would need this for all the links in the powerpoint file. Is this possible?  
Question by:error_prone
    LVL 21

    Accepted Solution


    Author Comment

    What is the Pack and Go feature?  Will that let me change my links?
    LVL 21

    Expert Comment

    Pack and Go was last available in PowerPoint 2000:
    Newer versions of PowerPoint have the Package for CD feature:
    Both allow you to package your presentation and linked files into a single directory changing the path of the links.  See this article about links and paths:

    Author Comment

    I'll try the Pack and Go and see if that works.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    This article shows how to simulate drawing numbers or names from a hat or bag using vba in PowerPoint and prevents duplicate items being selected. It’s not difficult to choose a (semi) random number in vba. The RND function returns a decimal numb…
    Introduction In all recent versions of PowerPoint it is possible to trigger animations. This means the animation takes place when a certain shape is clicked. This allows you to run animation “on demand” and outwith the normal sequence of mouse cl…
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now