+ Reply to Thread
Results 1 to 3 of 3

Hyperlink from Excel to file and target a specific Word in the file

  1. #1
    Registered User
    Join Date
    10-29-2007
    Posts
    49

    Hyperlink from Excel to file and target a specific Word in the file

    Because some of the material that is being hyperlinked to from an excel workbook are Word Documents this initial suggestion was accurate up to locating and loading the word doc but not searching and finding a specific word (target) in the word document.

    Looking for alternative suggestions - First Suggestion by Sandy666 - You need to create Bookmark in the word document first then in the Excel select insert hyperlink and add on the end of you path to the word document #name_of_bookmark
    eg. Z:\Temporary\test.docx#bookmark2

    ***ALERT******
    The location where the documents are located resides in a web based achieve - Somewhat like SharePoint – so the documents being searched for are HTML… There are Word Documents which that portion of the code is complete.

    The new question is:
    Is there a way to add a feature to the code that will search for a specific word (Target) in the HTML page once the page is located??…. The hyperlink style works but once the item is located there is nothing in this code that will search for a keyword in the HTML page..

    Any thoughts??? This may be a tuff one to solve!!

    John

  2. #2
    Registered User
    Join Date
    10-29-2007
    Posts
    49

    Re: Hyperlink from Excel to file and target a specific Word in the file

    Is it possible to create a link in excel to open a web page and go to a bookmark in that web page.... I created a link to can go to a web page but it does not go to the bookmark created...

    Any suggestions would be greatly appreciated

    John

  3. #3
    Registered User
    Join Date
    10-29-2007
    Posts
    49

    Re: Hyperlink from Excel to file and target a specific Word in the file

    Why can't a hyperlink work in excel to a web page bookmark?

    (Example - not actual link)
    http://www.website.com/webpage.html#target18

    It loads the page but does not go to the target

    John

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hyperlink from Excel file to open a Word Document and target a specific Bookmark
    By John Fletcher in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-19-2017, 10:42 AM
  2. Apostraphe in file path for hyperlink target a problem?
    By mlewis715 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-07-2016, 06:11 PM
  3. Replies: 1
    Last Post: 07-11-2015, 01:04 AM
  4. [SOLVED] Auto hyperlink file from specific folder after enter file name in cell
    By satputenandkumar0 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-12-2014, 06:11 AM
  5. Excel Hyperlink to location within same file from word within cell
    By dave1983 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-23-2014, 11:38 AM
  6. Replies: 1
    Last Post: 04-03-2014, 05:24 AM
  7. [SOLVED] Hyperlink word file to excel file with specific sheet
    By kumawat_s in forum Word Formatting & General
    Replies: 10
    Last Post: 08-10-2012, 07:41 AM

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