Solved Auto open word document in Excel hyperlink

November 2, 2015 at 16:57:09
Specs: Windows 7
In Excel 2010 sheet 1, I enter document name "Text.doc or docx" into column A1 cell. Is this possible the sheet1 A1 cell could auto search "Text" document from sheet 2 at column A "k:\project base\text.doc" if match on that hyperlink then auto open "text.doc" file.

Thanks for your help again.

See More: Auto open word document in Excel hyperlink

Report •

November 2, 2015 at 17:02:38
Not sure I understand what you want to do.

For a Hyperlink to work you must manually click on the Hyperlink.


Report •

November 2, 2015 at 17:20:32
For example:

If sheet 2 column A1, A2 and A3 already have 3 x hyperlinks on each cell.

A1. k:\project base\text.doc
A2. k:\project base\text1.doc
A3. k:\project base\text2.doc

When I type "text.doc" in sheet1 A1 cell. How can I make it auto search on this file and open it if that file exist?

Thanks for your help.

Report •

November 2, 2015 at 17:33:28
✔ Best Answer
To do it the way you wish,
IE: Enter a search string in Sheet 1, Cell A1
and then have excel automatically search Sheet 2 for the string
you will need a Macro.

Unfortunately my Macro skills are just above nil.

But, you can do something similar, using the built in Search & Replace:

Select the worksheets that you want to search by holding down the SHIFT key
and clicking the worksheet tabs.

On the Edit menu, click Find.

In the Find what box, type the data that you are searching for,
and then click Find Next.

You should be brought to the select cell and you can then click on the Hyperlink.

Not knowing how you have your sheets set up, you may have to change the
Search Options, to Values in the drop box labeled "Look In"


Report •
Related Solutions

Ask Question