application.followhyperlink adding correct text string

[sandman]

Received a hyperlink via an email
eg "Click here” hyperlink text



With a mouse hover over this link shows :file:///\\servername\folder\document

i dont have permission to use this server so cant test!


What do I add behind (Application.FollowHyperlink ) to be sure this will work ?

do I add the string as shown or simply omit ":file"

[June7]

Review http://allenbrowne.com/func-GoHyperlink.html

[sandman]

Thanks June 7, I have already read that article, but i do not want to add a module for 1 hyperlink. I see that his function prepends "file///" does that means i include it in mine???

[June7]

That's why I referenced the article. Seems to indicate the prefix is acceptable. I tested using the prefix. I had to remove the first colon and then it worked.

But if you can't access that server, why do you have this link? How do you plan to use it?

[sandman]

this particular db is not destined to be used by me.

If I understand you correctly the finished path should be

Application.FollowHyperlink "file///\\servername\folder\document", , true


with the colon removed from behind "file"

[Welshgasman]

application.FollowHyperlink "file://\\dlink323\Volume_1\fan.log" works for me?

[June7]

Your original example showed 2 colons. I said remove the first colon.

[sandman]

Thanks to you both for the input. I've marked this as solved!