Cheers Bill,

With your help I've now solved the problem. I was saving the individual
sheet as html rather than the 'entire workbook'. With the hyperlink base in
place the link in html reads correctly:

<a href="file:///\\server\folder\file.pdf"file</a

"Bill Manville" wrote:

Alastair wrote:
unfortunately it still will not work, the HTML code
for each link still reads:

href="folder/file.pdf"


If you create a new hyperlink, with the hyperlink base set as I
suggested, does it come out right?
If so all we need is to fix up any existing hyperlinks which should be
possible using some code.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup