J
jamie
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
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