I want to use an environment variable as a htperlink base in Word and Excel.
For example a variable DOCUMENTS may be set as c:\mystuff\documents and then
a hyperlink would be relative to it in a document. If I use
c:\mystuff\documents as the hyperlink base it is fine, but I can't see how to
use the variable DOCUMENTS. %DOCUMENTS% doesn't seem to work.