Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default how do i create hyperlink from range of filename

i have a big collume range of file names (documents list) which i want to
create hyperlink to.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,058
Default how do i create hyperlink from range of filename

Say in column A we have cells like:

C:\x.txt

with the path and filename. In B1 enter:

=HYPERLINK(A1,A1) and copy on down.
--
Gary''s Student - gsnu200796


"bobojr" wrote:

i have a big collume range of file names (documents list) which i want to
create hyperlink to.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I Hyperlink to document using filename in cell? Matt Bennette Excel Worksheet Functions 3 December 10th 08 10:24 AM
Create hyperlink without filename? [email protected] Excel Worksheet Functions 4 April 20th 07 01:30 AM
Hyperlink using filename trimm54 Excel Worksheet Functions 2 February 15th 06 11:41 AM
Store hyperlink, when filename may have # in the name? Larry[_9_] Excel Programming 1 January 13th 06 11:43 PM
hyperlink filename # HAS Excel Discussion (Misc queries) 1 December 21st 05 04:07 PM


All times are GMT +1. The time now is 05:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"