?
Solved

Change Links through VBA

Posted on 2007-07-30
4
Medium Priority
?
989 Views
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?  
C:\Data\ABC\Workbook.xls!Sheet1!R1C2:R66C17
0
Comment
Question by:error_prone
  • 2
  • 2
4 Comments
 
LVL 21

Accepted Solution

by:
GlennaShaw earned 2000 total points
ID: 19599525
0
 

Author Comment

by:error_prone
ID: 19622044
What is the Pack and Go feature?  Will that let me change my links?
0
 
LVL 21

Expert Comment

by:GlennaShaw
ID: 19622180
Pack and Go was last available in PowerPoint 2000: http://office.microsoft.com/en-us/powerpoint/HA011552791033.aspx
Newer versions of PowerPoint have the Package for CD feature: http://office.microsoft.com/en-us/help/HP052419631033.aspx
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: http://www.pptfaq.com/FAQ00155.htm 
0
 

Author Comment

by:error_prone
ID: 19622189
I'll try the Pack and Go and see if that works.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
A lot of things can happen during a presentation, worst of which is “death by PowerPoint.” Here are a few mistakes to avoid to make your slides clean.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

850 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