Results 1 to 13 of 13
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    FInding missing links (2000, XP, 2003)

    I've been working on a utility to fix broken links very recently.

    I have just published the first Beta:

    http://www.jkp-ads.com/downloadscript.asp?...LinkUtility.zip

    Open the utility, then upen your file with broken links, then select tools, fix broken links.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: FInding missing links (2000, XP, 2003)

    Hello Jan Karel,

    It looks promising. but there seem to be some rough edges.

    1) When I tried "Fix broken links" dialog, the "drives to search in" box contained three check boxes:
    - The first for the C: drive (correct)
    - The second didn't correspond to any drive, but I could tick the box, and it acted as if it was the C: drive.
    - The third didn't correspond to any drive either, and I couldn't tick the box.

    2) One of the times I let the utility search for a file, it hung for minutes on a folder that doesn't contain any Excel files.

    3) I couldn't discover if and how Search and Replace mode works.

    4) When is the List Links button enabled?

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: FInding missing links (2000, XP, 2003)

    Hi Hans,

    Thanks much for your comments.
    Ad 1: I'll check against the problem you describe.
    The last item in the drives list is there because it avoids you cannot see the last available drive entirely (listbox bug). Hence it has no text and cannot be selected.
    Ad 2: Strange. Does that folder contain many files?
    Ad 3: It would search in the path of an existing (missing) link for the string you enter in the search box. It will replace that occurance with the replace string.
    Ad 4: List Links button needs to be removed.

    Thanks again.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: FInding missing links (2000, XP, 2003)

    > Does that folder contain many files?

    No, it was a folder with 20 small .jpg files. However, the problem didn't reoccur later, so it may just have been a glitch.

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: FInding missing links (2000, XP, 2003)

    <hr>the problem didn't reoccur later<hr>
    Good.
    BTW: I've updated the download. I decided to get rid of the clickable nodes in the treeview and moved everything that does an action to buttons.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: FInding missing links (2000, XP, 2003)

    Hi Jan Karel,

    I tried this facility soon after you posted it and I was a little confused as to what it does? I created a little file that had a link to another workbook. Then I ran this utility to see what it does. I think I am mis-understanding the context of the feature. Could you please explain in more detail exactly when and why you will use this!

    Tx
    Regards,
    Rudi

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: FInding missing links (2000, XP, 2003)

    Try the following:
    - Close the workbook with the external link.
    - Use Windows Explorer to move the source file of the external link to another folder.
    - Reopen the workbook with the external link.
    - Run Jan Karel's utility. It will show the now incorrect link in red, and you can let it search for the source file.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: FInding missing links (2000, XP, 2003)

    Looks good!

  9. #9
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: FInding missing links (2000, XP, 2003)

    Doing a quick test using files on my C: drive, I get a lot of Error 52 messages popping up (something about an invalid filename) - not sure why. Other than that, it seems to work well - certainly found and fixed my quick test!
    Regards,
    Rory

    Microsoft MVP - Excel

  10. #10
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: FInding missing links (2000, XP, 2003)

    OK....I think I know where I went wrong. Of stead of moving the file to another folder, I <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30> renamed the file! I guess that is why it did not find it!!!
    <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15> No there is the next project Jan can tackle....finding and fixing links to renamed files.....
    Regards,
    Rudi

  11. #11
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: FInding missing links (2000, XP, 2003)

    Error 52's? I'll check what those are about. Thanks.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  12. #12
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: FInding missing links (2000, XP, 2003)

    <hr>renamed the file<hr>
    Well, you can search for non-exact matches, but all that does is put a * before and after the filename:

    *TheFile*
    Yields:

    Copy Of TheFile.xls
    TheFile 03-02-2006.xls
    TheFile Version 2.xls
    Lost TheFile.xls <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    .....
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  13. #13
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: FInding missing links (2000, XP, 2003)

    Cheers
    Regards,
    Rudi

Posting Permissions

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