Hi Guys, a pointer please. I want to create a hyperlink from one workbook to a cell in another book.
At the time of creation, both books are open. I am not sure of the exact syntax to use. I have been trying to get this right for some time without any luck.
I have values for the full path to the open workbook, the sheet name to which the link is to be made and also the cell address, these are stored in separate variables.
e.g C:\MyFiles\MyWorkbookName.xlsx, Sheet3, Cell f5
The method I am using is Cellx.Hyperlinks.Add , Anchor:= Cellx, Address: = ?
Any help please?