Technical forums » Office applications »
How to convert file names in Excel to hyperlinks
Thread poster: Tangopeter
Tangopeter
Tangopeter

Local time: 18:54
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 co... See more
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] ▲ Collapse
 
Hynek Palatin
Hynek Palatin  Identity Verified
Czech Republic
Local time: 18:54
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
Henrik Pipoyan  Identity Verified
Local time: 20:54
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
Tangopeter

Local time: 18:54
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:

Moderator(s) of this forum
Maya Gorgoshidze[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

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

How to convert file names in Excel to hyperlinks






CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

Buy now! »
Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »