Hello,

Our accounting software creates an excel report that contains a link
to an image. (file://H:\xxxxx\xxxx\xxxxx.tif) for example.

The problem is we want to replace the path to the image with something
that will point to a folder on a dvd for example.  We will not be able
to control which drive letter the end user will use.

My questions then;

Is there a way to change the path in the link without interacting with
each one?  There are well over 1000 links in each spreadsheet.

Is there a way to make the new path relative to the location of the
spreadsheet file?

Thanks so much,

k