Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Linking question

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have several workbooks with links to other workbooks, Some of these links were create in the process of testing macros and such.

    What I am trying to do now is remove those bad links. But I can not find where that is done at. I looked at edit links, and I can redirect links there and update them, but I don't see the option to just irradicate them. Anyone else ever had this problem?


  2. #2
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-19 09:32, kluitna wrote:
    I have several workbooks with links to other workbooks, Some of these links were create in the process of testing macros and such.

    What I am trying to do now is remove those bad links. But I can not find where that is done at. I looked at edit links, and I can redirect links there and update them, but I don't see the option to just irradicate them. Anyone else ever had this problem?

    I have written some code to identify links. Have a look at:

    http://ca.geocities.com/b_davidso/We...k_listing.html

    If you need any help with implementing this just let me know.

    Regards,
    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for the code Barrie, I can see where it will come in handy in the future as this monster I am creating grows.

    My current project really does not have that many links in it. Its just hat I can't get rid of the ones I have. Its irritating me. My ultimate goal is to create a series of workbooks that are linked together. But here is the tricky part. They will be a template for other users, so I want the links only to be estabished after a end user has moved the template workbooks to there final destination. Then they just hit a tool bar button and wall la the links are established in the correct paths. I hace the code to do this now. It will work really slick. now my problem is getting rid of all the bogus links I created to figure out that code. SO I can have a clean copy of the workbooks. Anyone have any ideas

  4. #4
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you want to browse the contents of your cells, press ctrl & ~ at the same time. this makes it easy to browse, replace, delete, etc...Press ctrl & ~ to get back to value view mode.

    Hope this helps.

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Helps allot Nate,

    Thanks for all the help, to both you and Barrie, This is strating to make allot more sense now.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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