Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute hyperlink
Gents I'm using VBA in Excel to created hyperlinks to files. VBA
creates absolute hyperlinks and this works fine. But when I save the file on the same server it changes the hyperlink from absolute to relative, which conflicts with other features in my VBA code. Could anybody please help me with this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute hyperlink
You could try changing the hyperlink base to c:\.
File|properties|summary tab But I'd use the =hyperlink() worksheet function. I've never seen it fail. =hyperlink("File:////\\server\path\filename.ext","Click me") Robert wrote: Gents I'm using VBA in Excel to created hyperlinks to files. VBA creates absolute hyperlinks and this works fine. But when I save the file on the same server it changes the hyperlink from absolute to relative, which conflicts with other features in my VBA code. Could anybody please help me with this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Absolute cell reference will not remain absolute. | Excel Worksheet Functions | |||
Hyperlink to another worksheet to a absolute cell | Excel Worksheet Functions | |||
why is absolute hyperlink in XLS file changed when file is saved | Excel Discussion (Misc queries) | |||
CAN A HYPERLINK HAVE AN ABSOLUTE COLUMN & RELATIVE CELL REFERENCE. | Excel Worksheet Functions | |||
How can I do an Absolute Cell Reference but non Absolute Cell Pais | Excel Programming |