title: Excel Hyperlink - using hyperlink base address
body: <p>I have been using the following hyperlink function to provide a link to a file based on the value of cell <code>B3</code> — the function is located in cell <code>L3</code> (and in <code>Bn</code> and <code>Ln</code>, as required).</p>
  
  <pre><code>=HYPERLINK(env("AGScan")&amp;"\photos\"&amp;B3&amp;".jpg","photos\"&amp;B3&amp;".jpg")
  </code></pre>
  
  <p>As you can see this function uses the value of an Environment Variable called <code>AGSCAN</code> to provide the location of the file — in this case it would be <code>C:\Data\Catalog</code> — now using an environment variable is a bit restrictive — I would like to use the Hyperlink Base option instead since this is much easier to change and specify the file location in the hyperlink base in the Excel worksheet properties.</p>
  
  <p>I can't seem to work out how to modify the above Hyperlink function to do this. Can anyone help me?</p>