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 |
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 |
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 |
All times are GMT +1. The time now is 11:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com