Replace partial hyperlink address

[uppie1]

I trying to use the hyper link base in excel and just use the trailing hyperlink address for the cell. For example, I want to change the following unique cell hyperlink

http://host/methodology/pak/contents/varies.asp

to
/pak/contents/varies.asp

I then can use the hyperlink base of:

http://host/methodology

ExcelPipe does not find the string "http://host/methodology", when I do a find.

Is there any way to replace a partial of a hyperlink address?

[DataMystic Support]

Yes, ExcelPipe allows this. Did you check the 'Hyperlink addresses' location?

[DataMystic Support]

Please download the latest version - we've just done a bug fix release,
http://www.datamystic.com/excelpipe2.exe