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.
 

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

Similar Threads


Back
Top