Thread: how do i create hyperlink from range of filename
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
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 With QuoteReply With Quote