Results 1 to 9 of 9

Application.FollowHyperlink

This is a discussion on Application.FollowHyperlink within the Microsoft Access forums, part of the Question Forums category; I have the code below in the On Click event of a command button I am using to open the ...

  1. #1
    Board Regular
    Join Date
    May 2007
    Location
    Caribbean
    Posts
    314

    Default Application.FollowHyperlink

    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.
    Love Life!!!!

  2. #2
    MrExcel MVP boblarson's Avatar
    Join Date
    Nov 2008
    Location
    Portland, Oregon, USA
    Posts
    1,961

    Default Re: Application.FollowHyperlink

    You should look here. And possibly here.
    Bob Larson
    Access MVP (2008-2010, 2011)
    Free Access Samples and Tutorials
    (includes Free Frontend Auto Update Enabling Tool).


  3. #3
    Board Regular
    Join Date
    May 2007
    Location
    Caribbean
    Posts
    314

    Default Re: Application.FollowHyperlink

    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.
    Love Life!!!!

  4. #4
    New Member
    Join Date
    Oct 2012
    Posts
    3

    Default Re: Application.FollowHyperlink

    Quote Originally Posted by boblarson View Post
    You should look here. And possibly here.
    Bob,
    The second link does not have the sub Nz in it. Do you have it somewhere for me to try?
    Thanks !

  5. #5
    MrExcel MVP
    Moderator
    SydneyGeek's Avatar
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    12,185

    Default Re: Application.FollowHyperlink

    Nz is a built-in function. Did you get an error?

    Denis
    Self-preservation: For when you've got yourself in a jam
    ------------------------------------------------------
    My site contains a number of Excel and Access Resources

  6. #6
    New Member
    Join Date
    Oct 2012
    Posts
    3

    Default Re: Application.FollowHyperlink

    Quote Originally Posted by SydneyGeek View Post
    Nz is a built-in function. Did you get an error?

    Denis
    Yes, I got an error. I am writing Excel VBA codes of Office 2007. Is this for Access? Can I use for Excel?

    Eric

  7. #7
    MrExcel MVP
    Moderator
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    26,994

    Default Re: Application.FollowHyperlink

    Yes, I got an error. I am writing Excel VBA 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).
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  8. #8
    New Member
    Join Date
    Oct 2012
    Posts
    3

    Default Re: Application.FollowHyperlink

    sorry. new to this forum.

  9. #9
    MrExcel MVP
    Moderator
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    26,994

    Default Re: Application.FollowHyperlink

    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!
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com