Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    USA
    Posts
    223
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Change Relative links to Absolute (2000 sp3)

    I've been reading all kinds of posts here and on other sites about absolute and relative links in PowerPoint and I still can't figure them out. I have a large app using several of the Office suite programs which we distribute to other users. Several of the files are .ppt presentations with links to data in the main Excel workbook. One of our features is to create a copy of the whole folder and file structure of the app and rename various components (including the name of the Excel workbook that is the source for the .ppt links) to customize it for the user. Long story short, as part of that customization in Excel I wrote automation code to rebuild the links in both the PowerPoint presentations and a Word document. The Word code works great. I'm going nuts with the .ppt code!
    I think we must have created the links as relative links. When we move the .ppt files the links change their paths. When I execute the code and step through it with the de###### I can see that the object.linkformat.sourcefullname is being changed correctly. I can click on the open presentation and see that the links appear to be correct even after the automation code does the save of the file. I can confirm that the file is saved by the date stamp in Windows explorer. Yet, when I open the file and click cancel to the question about updating the links, and then look at the links (Edit, Links) they look as if they haven't been affected by the running of the code. If I close the .ppt file, reopen it and click OK to the update question, the file it tries to open doesn't exactly match the path and file I tried to change it to or the path and file file that appears in the Edit, Links window. HELP!!! Is there more than one place this data is stored?
    Any ideas would be most appreciated! I saw ads for Link rebuilding software, do I need to buy something like this?
    It seems if I create a new presentation and create the links correctly as absolute links, my code works. If I try adding absolute links to a presentation that has relative links, those links appear to be relative links also, that is, the path changes when I move the file to another folder.
    I've attached a text file of the main part of the code I'm using for each shape in each slide (also slidemaster and titlemaster slides):
    Thanks in advance to anyone who can help!

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Change Relative links to Absolute (2000 sp3)

    Hi there, I know this is an old post, but I have just seen it.

    I have read this through and have a <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15> "out of the box" thought. If you are distributing these files to many users could you not have the files in one folder with absolute links to the files within the folder and then create a self-extracting zip file. On runtime you could request the users to place in, say, C:MyPPTShow. This would allow all files to downloaded to that folder location without the need to change the paths....or have I missed your point. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Jerry

  3. #3
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    USA
    Posts
    223
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Change Relative links to Absolute (2000 sp3)

    Well Jerry, there are several points here, but you certainly didn't miss the most important one! This is a workable solution to the distribution problem and one we have explored. I have a broader post in the Excel forum which goes into much more detail about the bug we found in PowerPoint concerning the changing of source for links. Now that Microsoft has investigated this bug I will post a reply on that forum.
    Thanks for your response!
    Merry Christmas!

  4. #4
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    USA
    Posts
    223
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Change Relative links to Absolute (2000 sp3)

    <P ID="edit" class=small>(Edited by WendellB on 14-Dec-05 10:52. Activate link to referenced post)</P>Oops! My other <post#=532024>post 532024</post#> is on this same forum (PowerPoint), not the Excel forum.
    Thanks

Posting Permissions

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