Results 1 to 6 of 6

Thread: hyperlink macro

  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Location
    St Georges du Bois, Pays de la Loire
    Posts
    84
    Thanks
    0
    Thanked 0 Times in 0 Posts

    hyperlink macro

    I am trying to write a macro, for use with MacroButton, that will function as a hyperlink for use on an intranet.

    Is there a standard Word macro for this and, if so, how do you use it?

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: hyperlink macro

    It probably would be easier to use the Insert Hyplerlink (ctrl+k) dialog than a macro button, but if that doesn't do what you need, please describe this in a bit more detail. The person will have a Word document open, double-click a MACROBUTTON field, and you want to open a particular HTML page in the browser... or...

  3. #3
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Sun Prairie, Wisconsin, Wisconsin, USA
    Posts
    2,049
    Thanks
    124
    Thanked 119 Times in 116 Posts

    Re: hyperlink macro

    I am assuming that this is for use in a protected form where a normal hyperlink will not work. If so, you need to record a macro (saving said macro in your form's template) opening the linked document. Then edit the macro using the VBA editor and make sure that the link is to a document path that will be recognized by any user of your form. (This is probably easiest if you have the linked document on a network drive that is mapped the same way on each user's computer or if you have the linked document in the same folder as the linking form.)

    You might want to consider putting the link in a non-protected portion of your form so that you can use an ordinary hyperlink field instead of the macrobutton. Hope this helps.
    Charles Kyle Kenyon
    Madison, Wisconsin

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: hyperlink macro

    I haven't played with fields in forms, and I'm not clued up on the real needs here.

    Would an alternate solution be a hytperlink in the form which points to a hyperllink in a second document which points to a hyperlink to the third and final document? It means TWO clicks instead of one, but might have the advantage of allowing exaplanatory text accompanying the link in the second document, or even a set of alternate choices (several hyperlinks) in that second document?

    My mind is struggling to come up with a problem that fits this solution.

  5. #5
    turtleshelby
    Guest

    Re: hyperlink macro

    <img src=/S/lightbulb.gif border=0 alt=lightbulb width=15 height=15>I know what I need it for. I want to link the page number in the index to the paragraph of the text for a manual made up of several hundred separate Word documents going on a intranet. The users will not have Word capabilities but see it in Acrobat Reader. It will come up on the Intranet as a Listing of all the Document names in HTML & hyperlinked to the respective document which opens to the document index and I need the link from there to the text. Bookmarking inside the xe field & hyperlinking that does not work because the links can not be locked or recovered & disappear every time you update the index.

    All that said, Anybody got the Macro?

    I really REALLY need it or a linked index like the Table of Contents which I can't alphabetise without losing the links!

    Frustrated

  6. #6
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Sun Prairie, Wisconsin, Wisconsin, USA
    Posts
    2,049
    Thanks
    124
    Thanked 119 Times in 116 Posts

    Re: hyperlink macro

    There was an article in the VBA Developer magazine on how to make the index act as a hyperlink to the indexed item but I haven't been able to find it. I believe that I posted something on it earlier in a different thread though. I'll keep looking.
    Charles Kyle Kenyon
    Madison, Wisconsin

Posting Permissions

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