Hi All

I'm having some difficulty with hyperlinks in Excel. I have a VBA script
which generates new cells in a document, each cell is hyperlinked to a
document stored in a diff directory. The code generates an absolute path to
the linked document. It all works fine, except that the next time the
spreadsheet is saved _all_ the hyperlinks in the sheet are changed to a
relative pathname, one that is no longer valid. I can suppress this annoying
behavior by navigating to Tools-Options-General-Web options-Files and
deselecting "Update Links on save". However, many people open and save this
document.

So, does anyone know how can I keep Excel from destroying the hyperlinks I
create in my script?

Thanks!