Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink Issue
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink Issue
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" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink Issue
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 "Barb Reinhardt" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink Issue | Setting up and Configuration of Excel | |||
hyperlink issue | Excel Discussion (Misc queries) | |||
Issue hyperlink in cell | Setting up and Configuration of Excel | |||
Full hyperlink issue, please help - end of my tether lol | Excel Programming | |||
Urgent: Hyperlink Issue | Excel Programming |