I want to create a button (macro) that when pressed opens another
spreadsheet (hyperlink).

The problem is that when the two spreadsheets are placed on someones
computer, obviously the link changes! In other programs I can use
%sourceDRV%/spreadsheet2.xls as the link and that causes the program
(Autoplay media for example) to search the same drive & location that
the first spreadsheet is on.

Is there anything I can use in VB to do the same thing?

As always...Thanks in advance

Jamie