LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Creating hyperlinks to network files


I am trying to create a macro so that I can click a button and
hyperlink is created, referencing a network location where the locatio
is dependent upon a value in another cell.

So for example, the hyperlink to be created in cell E3 would b
"=hyperlink("G:\General\Blah\Blah\"cell A9"\file.pdf")"

Also, I want the hyperlink text to just say "ABC"

How does this happen

--
akronpo
-----------------------------------------------------------------------
akronpow's Profile: http://www.excelforum.com/member.php...fo&userid=2910
View this thread: http://www.excelforum.com/showthread.php?threadid=48821

 
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
Navigating to Excel files over network slow, but not Word files Newbie123 Excel Discussion (Misc queries) 1 December 2nd 09 01:18 PM
Network Files creating temporary files Dave Weastec Excel Discussion (Misc queries) 0 October 3rd 08 02:26 PM
Hyperlinks to files on network drivers Fornol New Users to Excel 3 February 22nd 06 11:10 PM
Hyperlinks to network files Tommc49 Excel Discussion (Misc queries) 0 June 25th 05 09:59 PM
Copying files ...Network to Network Eric[_6_] Excel Programming 2 July 18th 03 08:59 PM


All times are GMT +1. The time now is 01:50 PM.

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

About Us

"It's about Microsoft Excel"