Followhyperlink with #

[rejome]

I'm trying to open a file with followhyperlink. I got an error cause the name of my file is "Excel #54.xls" and the sharp is seen as an html tag...well I think. Any suggestion to bypass this?

 

[PHV]

Say you have s = "Excel #54.xls"
Have you tried something like this ?
s = Replace(s, "#", "%23")

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[rejome]

Sorry PHV, it didn't work. Here's the code I tried:

s = "\\files\Excel #.xls"
s = Replace(s, "#", "%23")
Application.followhyperlink s