Something between a button and a hyperlink....

Posted on 2011-04-24
Last Modified: 2012-05-11
Excel 2003.  I want to link a bunch of documents to a worksheet.  The problem is that the documents will be in a "relative" folder structure, that is, the "top" folder may move, but the sub-folders will stay the same.

I would use a button except that I need to put the button in a row that's going to be part of a group that will be hidden and unhidden, and the button won't hide.

I would use a hyperlink except I don't know how to make a hyperlink have variability, unless there's an event that I could use to capture the hyperlink and modify it.  I've done something like that in ASP.NET or Access, but not Excel.

Third option might be to put the documents in SharePoint where they really would be in more or less fixed locations, but that's a different approach.

Fourth option would be to embed the documents but they wouldn't hide and the .xls would get very large.

Any suggestions about this would be appreciated.


Question by:codequest
    LVL 2

    Accepted Solution

    for this, leave out the path from the drive and all..

    for example if your structure is like this:


    if the main folder will be moved to different locations,

    refer to the files in sub\ by mentioning:
    give the sub\abc.xls

    it will work anywhere the file is..

    hope this helps!!!
    LVL 2

    Author Comment

    That works.   I'm going to reward points and ask a related question.  Thanks!

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

    746 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

    16 Experts available now in Live!

    Get 1:1 Help Now