C
Cadwan
I'm using a VB Macro to enter Hyperlinks in an Excel spreadsheet, on the
server, but when I copy the server spreadsheet to local stations the
hyperlink path becomes unusable. Why do these hyperlinks keep changing?
Anybody?
Code example:
PO_Filename = "\\server01\server\00-Purchase Orders\" & PO_PONo & _
"-" & P
rdnam & "-" & PO_Vendnam & ".xls"
With Worksheets(1)
.Hyperlinks.Add Anchor:=.Range(cell_no), _
Address:=PO_Filename, _
ScreenTip:=PO_Filename, _
TextToDisplay:=PO_PONo
End With
server, but when I copy the server spreadsheet to local stations the
hyperlink path becomes unusable. Why do these hyperlinks keep changing?
Anybody?
Code example:
PO_Filename = "\\server01\server\00-Purchase Orders\" & PO_PONo & _
"-" & P
rdnam & "-" & PO_Vendnam & ".xls"With Worksheets(1)
.Hyperlinks.Add Anchor:=.Range(cell_no), _
Address:=PO_Filename, _
ScreenTip:=PO_Filename, _
TextToDisplay:=PO_PONo
End With