I have been asked by a colleague how to insert a hyperlink from one workbook to a specific sheet in another workook. I have looked through the site and it appears that the details are
\\w2k3-bsp1\Data\HRDATA\MA\StewartS\TEST\BLIB O12 Account Analysis full Download Check.xlsx - 'sheet4'!a1
but when I try it I get the message Cannot open the specified file. I assume it is something to do with the way the sheet details are shown. Can anybody help please.
Thanks
StewartS
\\w2k3-bsp1\Data\HRDATA\MA\StewartS\TEST\BLIB O12 Account Analysis full Download Check.xlsx - 'sheet4'!a1
but when I try it I get the message Cannot open the specified file. I assume it is something to do with the way the sheet details are shown. Can anybody help please.
Thanks
StewartS