| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a Macro to Hyperlink to another Excel Workbook.
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| E-mail Excel workbook as hyperlink | Excel Discussion (Misc queries) | |||
| Hyperlink two sheets in a Excel Workbook | Excel Worksheet Functions | |||
| Using a Hyperlink to send a MS Excel Workbook to Recipient | Excel Discussion (Misc queries) | |||
| how can I create a save file hyperlink or macro in a workbook? | Excel Programming | |||
| Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
Threaded Mode
