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

Tangopeter

Local time: 16:56
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]


 

Hynek Palatin  Identity Verified
Czech Republic
Local time: 16:56
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


 

Henrik Pipoyan  Identity Verified
Local time: 18:56
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.


 

Tangopeter

Local time: 16:56
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.


 


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






BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, ProZ.com integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »



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