How to convert file names in Excel to hyperlinks
Thread poster: Tangopeter
Tangopeter

Local time: 20:14
English to Dutch
+ ...
Dec 30, 2009

Hi,

I have some lists (columns) of file names (of files on my hard drive) that I want to turn into hyperlinks.
E.g. filename1.txt becomes a hyperlink with address file:///C:\foldername\filename1.txt, and filename2.txt becomes a hyperlink with address file:///C:\foldername\filename2.txt, etc.

I know that I can do this, of course, via the Insert menu, but as these are rather long lists, I am looking for a macro to do this.

Does anybody know of a way to do this 'in an orderly manner'?

Thanks in advance,
Peter

[Edited at 2009-12-30 13:23 GMT]


Direct link Reply with quote
 

Hynek Palatin  Identity Verified
Czech Republic
Local time: 20:14
English to Czech
+ ...
Hyperlinks Dec 30, 2009

Hi Peter,

You can use the =HYPERLINK() function or the following macro:
http://en.allexperts.com/q/Excel-1059/2009/3/Converting-File-path-Hyperlink.htm

Hynek


Direct link Reply with quote
 

Henrik Pipoyan  Identity Verified
Local time: 23:14
Member (2004)
English to Armenian
Hyperlink formula Dec 30, 2009

Hi Peter,

In MS Excel you can do it in the following way:

If the filenames are in Column A, in B1 insert the following formula:

= HYPERLINK("file:///C:\foldername\"&A1)

Then fill down column B up to the last line of your list.


Direct link Reply with quote
 
Tangopeter

Local time: 20:14
English to Dutch
+ ...
TOPIC STARTER
Works like a charm! Dec 30, 2009

Wow, Henrik, that is very efficient indeed! And very easy to adapt.
(And yet another advantage: no nagging MS Office security windows asking for confirmation;-)

Thank you!

Thank you too, Hynek. Adding it to my macro collection.


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

How to convert file names in Excel to hyperlinks

Advanced search






SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »
WordFinder
The words you want Anywhere, Anytime

WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search