Technikai fórumok » Office applications »
How to convert file names in Excel to hyperlinks
Téma indítója: Tangopeter
Tangopeter
Tangopeter

Local time: 05:05
angol - holland
+ ...
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
Csehország
Local time: 05:05
angol - cseh
+ ...
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: 07:05
Tag (2004 óta)
angol - örmény
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: 05:05
angol - holland
+ ...
TÉMAINDÍTÓ
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:

A fórum moderátora(i)
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






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

Buy now! »
Trados Business Manager Lite
Create customer quotes and invoices from within Trados Studio

Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.

More info »