Prev: How to extract the number of pages in a cell (Excel 2003)
Next: Printing in excel always comes out in bold even tho bold not on
From: jw4774 on 26 Mar 2010 06:01

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?



 | 
Pages: 1
Prev: How to extract the number of pages in a cell (Excel 2003)
Next: Printing in excel always comes out in bold even tho bold not on