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.