Hyperlink Issue

[Barb Reinhardt]

I have code that extracts data from multiple workbooks and puts hyperlinks
back to the original workbook. This used to work and now I'm having issues
with it.

When the hyperlinks are added to the cells, they look something like this

Z:\ ....

After some additional execution, they change to this

.../../../../users/Barbara.Reinhardt

Any hyperlinks that look like this do not work. Any hyperlinks with Z:\
work. I've had issues with SP2 not being installed on my system and now my
WebClient service is not automatically started. Does anyone have any idea
what might cause this problem?

Thanks,

Barb Reinhardt

 

[Barb Reinhardt]

I have just determined that the hyperlinks change when I save the workbook
they are stored in. Good before aWB.save, bad after. Also, I'm saving
back to the Z drive, so it shouldn't get confused.

Thanks,
Barb Reinhardt

 

[Barb Reinhardt]

I've just found this KB article

http://support.microsoft.com/kb/q177888/

The original code adds the hyperlinks as described in the article.

aWS.Hyperlinks.Add Anchor:=aWS.Cells(lRow, WBName.Column), _
Address:=oldPath, _
TextToDisplay:=oWB.Name

Barb Reinhardt