H
hwange
I need a hyperlink to open a file then open a 2nd file straight after
with one click on the cell.
2 cells containing the seperate files to open are as follows.
1.
=HYPERLINK(("D:\PRN Files\misc\"&I3&"\"&A3&".prn"),"click here")
2.
=HYPERLINK(("D:\Images\misc\"&I3&"\"&A3&".jpg"),"click here")
I3 is the folder name and A3 is the filename
I need something like this (Just an eg so you know what I mean)
=HYPERLINK(("D:\PRN
Files\misc\"&I3&"\"&A3&".prn")(("D:\Images\misc\"&I3&"\"&A3&".jpg"),"click
here")
Thanks in advance
with one click on the cell.
2 cells containing the seperate files to open are as follows.
1.
=HYPERLINK(("D:\PRN Files\misc\"&I3&"\"&A3&".prn"),"click here")
2.
=HYPERLINK(("D:\Images\misc\"&I3&"\"&A3&".jpg"),"click here")
I3 is the folder name and A3 is the filename
I need something like this (Just an eg so you know what I mean)
=HYPERLINK(("D:\PRN
Files\misc\"&I3&"\"&A3&".prn")(("D:\Images\misc\"&I3&"\"&A3&".jpg"),"click
here")
Thanks in advance