Prev: automatic calculate at specific month
Next: changing the number of rows the mouse scrolls through
From: JJ on 24 May 2010 08:35
Hi

How do I hyperlink a cell to more than one PDF files?

Thanks

JJ
From: Luke M on 24 May 2010 10:09
You don't/cant. You could hyperlink to the folder containing multiple pdf
files, however.

--
Best Regards,

Luke M
"JJ" <JJ(a)discussions.microsoft.com> wrote in message
news:2D844D88-2892-4A72-8A25-9BFC915B8161(a)microsoft.com...
> Hi
>
> How do I hyperlink a cell to more than one PDF files?
>
> Thanks
>
> JJ


From: Dave Peterson on 24 May 2010 10:45
Or maybe you could replace the hyperlink with a macro that opens both .pdf
files???

Or (untested), you could hyperlink to a .bat or .vbs file that runs and opens
both files.

JJ wrote:
>
> Hi
>
> How do I hyperlink a cell to more than one PDF files?
>
> Thanks
>
> JJ

--

Dave Peterson
From: JJ on 25 May 2010 08:07
Dave
can you guide me as to hyperlink with a macro as this seems to be the better
option. I am not good with macros.

tx

"Dave Peterson" wrote:

> Or maybe you could replace the hyperlink with a macro that opens both .pdf
> files???
>
> Or (untested), you could hyperlink to a .bat or .vbs file that runs and opens
> both files.
>
> JJ wrote:
> >
> > Hi
> >
> > How do I hyperlink a cell to more than one PDF files?
> >
> > Thanks
> >
> > JJ
>
> --
>
> Dave Peterson
> .
>
From: Dave Peterson on 25 May 2010 09:29
If it's just a single cell that has that hyperlink...

Format the cell nicely -- make it look like a hyperlink (but make sure you
remove any existing hyperlink).

Now show the Drawing toolbar
View|Toolbars
in xl2003 menus

Place a rectangle over that cell so that it covers the text you want to make
look like a hyperlink.

You can hide the borders so that it looks pretty later.

Now hit alt-f11 (to get to the VBE, where macros live).
Click on Insert|Module on the VBE's toolbar.

Paste this into the newly opened Code window -- usually on the right hand side:

Option Explicit
Sub LoadPDFs()
ThisWorkbook.FollowHyperlink "C:\my documents\firstfile.pdf"
ThisWorkbook.FollowHyperlink "C:\my documents\secondfile.pdf"
End Sub

You'll have to change the path and filename for both files.

Now hit alt-f11 to get back to excel.

Rightclick on the rectangle and choose Assign macro
Point at LoadPDFs
and click ok

Then test it.

If it works, then it's time to hide the borders of the rectangle (if you want).

Rightclick on the rectangle
choose Format|autoshape
On the Colors and Lines tab, choose "no line" for the line





JJ wrote:
>
> Dave
> can you guide me as to hyperlink with a macro as this seems to be the better
> option. I am not good with macros.
>
> tx
>
> "Dave Peterson" wrote:
>
> > Or maybe you could replace the hyperlink with a macro that opens both .pdf
> > files???
> >
> > Or (untested), you could hyperlink to a .bat or .vbs file that runs and opens
> > both files.
> >
> > JJ wrote:
> > >
> > > Hi
> > >
> > > How do I hyperlink a cell to more than one PDF files?
> > >
> > > Thanks
> > >
> > > JJ
> >
> > --
> >
> > Dave Peterson
> > .
> >

--

Dave Peterson
 |  Next  |  Last
Pages: 1 2
Prev: automatic calculate at specific month
Next: changing the number of rows the mouse scrolls through