+ Reply to Thread
Results 1 to 5 of 5

Hyperlink Macro to Internet

  1. #1
    Registered User
    Join Date
    06-20-2004
    Posts
    7

    Hyperlink Macro to Internet

    Button Macro executes a hyperlink to a specific web internet page. However, if one is working offline or not connected to the internet and presses the macro link, the macro returns a "debug" message. Can the macro be edited to include an if statement in order to view web page, they must be connected to the internet and eliminate the "debug" window?
    ================ See marcro below=====================
    LinkInternet Macro
    ' Macro recorded 11/2/2007 by George
    '

    '
    Range("K6:N6").Select
    Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
    End Sub

    '
    '

  2. #2
    Forum Contributor
    Join Date
    11-23-2005
    Location
    Perth, Australia
    Posts
    218

    Hyperlink Macro to Internet

    Try something like the following :

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    06-20-2004
    Posts
    7
    Steel Monkey

    Your response code didn't work and I am wondering if it has to do something with the Excel Versions. Our workplace is using Excel 2003 and I wonder if the information that you gave me is for Excel 2007? The error message is compile error "Expected End Sub" I am in Japan and therefore on similar time zones. I am on my way home from work and I will test the code on my commputer which is excel 2007. I will execute the link online and also on offline. Let's see what happens. Thanks for your help... George

  4. #4
    Forum Contributor
    Join Date
    11-23-2005
    Location
    Perth, Australia
    Posts
    218

    Hyperlink Macro to Internet

    Are you sure you copied the entire macro in ?

    That error message is not caused by different versions. Post your revised code if your still having troubles

  5. #5
    Registered User
    Join Date
    06-20-2004
    Posts
    7

    Hyperlinks

    Thanks Steel Monkey....

    It works, I left out part of the code when I cut and paste. Thanks for a quick response and a solution to my problem.

    George

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1