Can a hyperlink open 2 files

  • Thread starter Thread starter hwange
  • Start date Start date
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
 
yes it can. but make sure that when you configure it, you
are also configuring the second hyperlink within that cell.
of course you could make it so that a macro could run both
of them simultneously, (but that is just a thought)

hope that helped.
 
Back
Top