J
jw4774
I am creating a new workbook and copying and pasting worksheets into it from
existing .xls files, and sucessfully copying hyperlinks across using the
PasteSpecial Paste:=x1PasteAll,
Command
The hyperlinks however are staying exactly as in the existing workbook and
failing to link to the object. Is there any way of moving the hyperlink
across so as to directly link to the object so that the link will change with
the location of the new workbook. Alternatively, there are only 3 links which
remain the same on all the work sheets I have tried to change afterwards
using:
/code/
CopiedSheet.Range("J10:J11").hyperlinks1.Add ActiveCell,
"Supporting%20Documents/M&R%20Master%20Record.xls", , "Click here to open
Master Record", "M&R Master Record"
/code/
but this hasn't worked and I can't figure out why, any pointers?
existing .xls files, and sucessfully copying hyperlinks across using the
PasteSpecial Paste:=x1PasteAll,
Command
The hyperlinks however are staying exactly as in the existing workbook and
failing to link to the object. Is there any way of moving the hyperlink
across so as to directly link to the object so that the link will change with
the location of the new workbook. Alternatively, there are only 3 links which
remain the same on all the work sheets I have tried to change afterwards
using:
/code/
CopiedSheet.Range("J10:J11").hyperlinks1.Add ActiveCell,
"Supporting%20Documents/M&R%20Master%20Record.xls", , "Click here to open
Master Record", "M&R Master Record"
/code/
but this hasn't worked and I can't figure out why, any pointers?