链接

Question

将文件Proble.xls放在c:\test下建立链接链接到c:\Old下menu.xls，链接成功，然后将Proble.xls放到D盘，链接失败，这是为什么：代码如下：     Row11= 6
     BugReportAddress=c:\Old\menu.xls
     PTSNo = Au2_P0123
     Cells(Row11, 2).Select
      ActiveSheet.Hyperlinks.add Anchor:=Selection, Address:= _
      BugReportAddress _
      ,TextToDisplay:=PTSNo

Answer 1

Row11= 6
     BugReportAddress=d:\Old\menu.xls  '这里改了吗？？？？？
     PTSNo = Au2_P0123
     Cells(Row11, 2).Select
      ActiveSheet.Hyperlinks.add Anchor:=Selection, Address:= _
      BugReportAddress _
      ,TextToDisplay:=PTSNo