専門的フォーラム » Office applications »
How to convert file names in Excel to hyperlinks
投稿者: Tangopeter
Tangopeter
Tangopeter

Local time: 07:35
英語 から オランダ語
+ ...
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
チェコ共和国
Local time: 07:35
英語 から チェコ語
+ ...
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: 09:35
2004に入会
英語 から アルメニア語
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: 07:35
英語 から オランダ語
+ ...
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:

このフォーラムのモデレーター
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






TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »
Trados Studio 2022 Freelance
The leading translation software used by over 270,000 translators.

Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop and cloud solution, empowering you to work in the most efficient and cost-effective way.

More info »