Using FollowHyperlink not working

Question

Using FollowHyperlink not working

Maxine Nietz 1

Have this code on a command button on a form. The field PDFName is also on the form. The filepath comes up OK. However, the line "Application.followhyperlink filepath,1,0" gives an error: RunTime Error 490; Cannot open the specified file." PLEASE HELP!!!!

Dim filepath As String

filepath = "C:\Users\nevadamax\OneDrive\Documents\PMPlus" & Me.PDFName

MsgBox filepath

Application.FollowHyperlink filepath, 1, 0

Maxine Nietz 1 Reputation point

2024-04-10T19:27:59.1666667+00:00

There is a \ after the PMPlus on line 2 of the code.
Maxine Nietz 1 Reputation point

2024-04-10T19:29:12.26+00:00

There IS a \ after the "PMPlus" on line 2 of the code. Don't know why it wasn't submitted.

2 answers

Your answer

Maxine Nietz 1 Reputation point

2024-04-10T19:27:59.1666667+00:00

There is a \ after the PMPlus on line 2 of the code.
Maxine Nietz 1 Reputation point

2024-04-10T19:29:12.26+00:00

There IS a \ after the "PMPlus" on line 2 of the code. Don't know why it wasn't submitted.

Answer 1

Tom van Stiphout 40,201 MVP Volunteer Moderator

Set a breakpoint, then in the Immediate window:
?filepath

Copy that text and put it in the Run box (WindowKey+R). What happens?

0 comments

Answer 2

Tom van Stiphout 40,201 MVP Volunteer Moderator

Set a breakpoint and in the Immediate window:
?filepath

Then copy that string and paste it into the Run box (WindowKey + R). What happens?

0 comments

Share via

Using FollowHyperlink not working

2 answers

Your answer