I want to create a hyperlink in my excel file that points to a specific
document. I same the master excel file to a new folder for every project I
do. The document I hyperlink to also is new for every project. How do I
automaticaly change the hyperlink to reflect the new folder / file location?
I wanted to set it up so that when I performed a "save as" on the master
document it would automatically change the hyperlink path to the new folder
location.

You coild work with Excels built in dialogue box to get the filename:

Code:
--------------------
Sub GetFileName()
Dim FileName As String
FileName = Application.GetOpenFilename
ActiveSheet.Hyperlinks.Add Anchor:=Range("a1"), Address:= _
FileName, _
TextToDisplay:="What will display in Excel Goes here"
End Sub
--------------------


Ben Davis;185144 Wrote:
I want to create a hyperlink in my excel file that points to a specific
document. I same the master excel file to a new folder for every
project I
do. The document I hyperlink to also is new for every project. How do I
automaticaly change the hyperlink to reflect the new folder / file
location?
I wanted to set it up so that when I performed a "save as" on the
master
document it would automatically change the hyperlink path to the new
folder
location.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=51144