followhyperlink with # symbol

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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"
 
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?
 
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.
 
Replace the question mark with the word Call, followed by a space.

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