Can a hyperlink open 2 files

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
 
L

loki

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top