followhyperlink with # symbol

R

rc51wv

this line of code is giving me problems:

Application.FollowHyperlink strLink

certain links have the "#" symbol in them, link C:\Folder # 282

It works absolutely fine with the folder locations that just have spaces,
but when "#" get's thrown in, it says it can't open the specified file. The
file name is not something I can change and is something that has to be
worked around. Is there a fix for this?

-Thanks in Advance
 
R

rc51wv

The code works, but causes an error which stops the program after opening the
folder picker.

"Run-time error '438':"
"Object doesn't support this property or method"
 
A

Allen Browne

What line generates this error?
Is it in the code you copied and pasted into the standard module?
Or is it in your original routine?
 
R

rc51wv

Sorry, wasn't specific enough. I have the function placed into a module and
it causes the error on the actual call.

When you use: ?fHandleFile(Me.txtLink, WIN_NORMAL), it substitutes the "?"
with "Print". It still opens the dialog box for the folder picker, but
creates an error at the same time. I used an error handler to ignore the
error and still open the box though.
 
A

Allen Browne

Replace the question mark with the word Call, followed by a space.

Then check that the code compiles (Compile on Debug menu.)
 
Top