Excel Help please!! I need to find a way to link to a file whose path is listed in a spreadsheet cell?

Question

I'm using a code to insert a file name of an external file into
a cell in an Excel spreadsheet, and it works fine. What I would really like
to do is make that file name a hyperlink to the file so I can click and open
it. I've searched many sites and tried many things but I just can't get it to
work for me.

Or is there a way to import an image into a cell from an external folder, by looking up the file path that has been returned by a LOOKUP function?


Thanks for looking at my question.

Answer 1

You did not say whether you wanted a formula or trying to do this with VBA code. Nor which version of MS-Excel is being used.



If you have both the directory path and file name already in a cell, then creating a hyperlink is fairly straight forward.



The HYPERLINK function creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet. When you click the cell that contains the HYPERLINK function, MS-Excel opens the file stored at link_location. The syntax for the function is as follows:



HYPERLINK( link_location, friendly_name )



Where "link_location" is the path and file name to the document to be opened as text. The "link_location" can refer to a place in a document — such as a specific cell or named range in an Excel worksheet or workbook, or to a bookmark in a MS-Word document. The path can be to a file stored on a hard disk drive, or the path can be a universal naming convention (UNC) path on a server (in MS-Excel for Windows) or a Uniform Resource Locator (URL) path on the Internet or an intranet.



The "link_location" can be a text string enclosed in quotation marks or a cell that contains the link as a text string.



If the jump specified in "link_location" does not exist or cannot be navigated, an error appears when you click the cell.



The "friendly_name" parameter is the jump text or numeric value that is displayed in the cell. And "friendly_name" is displayed in blue and is underlined. If "friendly_name" is omitted, the cell displays the link_location as the jump text.



The "friendly_name" can be a value, a text string, a name, or a cell that contains the jump text or value.



If "friendly_name" returns an error value (for example, #VALUE!), the cell displays the error instead of the jump text.



Remark:

---------------

To select a cell that has a hyperlink in it without jumping to the hyperlink destination, click the cell and hold the mouse button until the cursor becomes a cross, then release the mouse button.



EXAMPLE:

-------------------

The following assumes that all of the files are in single folder and the file names are in column D. You could have the hyperlink in column E, using the following formula:



= HYPERLINK( "C:\Users\Pollux\Pictures\" & D3, D3)



The above will display the file name found in cell D3, but would be a direct link to the file itself.



.

Answer 2

The best reverse cell phone lookup service that I have tried is http://reversephone.toptips.org



From using a reverse cell phone lookup you will be able to get the callers name and address just

by typing the phone numbers they will tell you the details related to the number.

The reverse cell phone lookup service has your details available they will give you the cell phones location. For a full report including a name and address and other interesting informations you will have to pay.

Enter the number in the system and they will tell you a lot of informations about the phone number and the person who owns it.

If they have extra details you will have to pay for the report.

Free reverse phone lookup sites generally provide the most basic of information such as name and it works only for landlines. To get further information, money will have to be paid. The free searches do not provide much more than what can be found through the phone book.

This service is great, I used it a lot f time with great results: I always obtained what I was searching for.

I definitely reccomend this service.

Answer 3

Depends what you are trying to do... If you find a Table in an HTML file you want 1 - in the HTML, Highlight all the elements in the table, Copy in Excel select where you want the table to appear, Edit > Paste Special > HTML or 2 - in Excel, look for the command Get External Data specify the full path or URL to the table and Import Hope this Helps

Answer 4

With Worksheets(1)

.Hyperlinks.Add .Range("A1"), "http://example.microsoft.com"

End With



Or this...



Range("A2").Formula = "=HYPERLINK(""C:\Path\File.xls"", ""FileName"")"