title: VBA excel, sheet copy but hyperlink is changed
body: <p>When I try to copy the whole sheet to another, every thing is fine except the hyperlink is changed to be started with "........\" instead with "http:\" in cells with hyperlink. </p>
  
  <p>The copy method is simple. I dont know why it happened. The following is my simple codes, copying sheet "temp1sheet" of temp1Workbook to sheet "LatestData" of PrimaryWorkbook. </p>
  
  <pre><code>'   copy data into the "master file"
  Windows(temp1Workbook).Activate
  Sheets(temp1Sheet).Select
  Range("A1").Select
  Range(Selection, Selection.End(xlToRight)).Select
  Range(Selection, Selection.End(xlDown)).Select
  Selection.Copy
  '   paste result, now there is a fresh list of Active
  Windows(PrimaryWorkbook).Activate
  Sheets("LatestData").Select
  Range("A1").Select
  ActiveSheet.Paste
  </code></pre>
  
  <p>Thanks for suggestion and help in advance.</p>