Forum Discussion
Open a path to a server from within excel
Hi, fundamentally I'm having a problem with opening a path to a printer server address
\\srv-print\prn0000
If i make this a hyperlink and klick it in word, outlook, or put it in to the UR...
Hi, that doenst work either for some reason it causes excel to become unresponsive and after a while it returns control, but nothing happens other than it locking up for a bit. :(
In that case I guess all I can think of is using a bit of VBA to do this.
Option Explicit
Sub OpenLinkUsingWord(sLink As String)
With CreateObject("Word.Application")
With .documents.Add
.FollowHyperlink sLink
.Close False
End With
.Quit
End With
End Sub
Sub Demo()
OpenLinkUsingWord "http://jkp-ads.com"
End Sub