Application.FollowHyperlink

koolwaters

Active Member
Joined
May 16, 2007
Messages
403
I have the code below in the On Click event of a command button I am using to open the Database User Manual.

Code:
Dim ManualFilePath As String

ManualFilePath = GetDBPath & "Help System/User Manual.pdf"
    Application.FollowHyperlink ManualFilePath

I am trying to figure out if there is a way to disable the warning that is received when following hyperlinks.

I tried Application.SetWatnings but that did not work.

Thanks for any assistance.
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
Thanks very much for your reply.

The second link seems like it is what I am looking for so once I understand what it is doing, I will give it a try.
 
Upvote 0
Yes, I got an error. I am writing Excel <ACRONYM title="visual basic for applications">VBA</ACRONYM> codes of Office 2007. Is this for Access? Can I use for Excel?
NZ is a function specific to Access, it does not exist in Excel.

If you have an Excel question, you should post it to the Excel forum, not the Access forum (and it is usually best to start a new thread with your question instead of tacking on to a question that was solved 2 years ago, especially since Bob is no longer active on this board).
 
Upvote 0
sorry. new to this forum.
That's OK. Just trying to help you along, to have the best chance of getting your question answered!;)
And welcome aboard!
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,953
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top