Hyperlink from Excel to a specific slide in PowerPoint

Does anyone know an easy way to hyperlink from Excel to a specific slide (say Slide 59) in a PowerPoint file using the hyperlink worksheet function. Thanks for your help.

Charlie -

You can't go to a particular slide from a hyperlink in Excel. You have
to use VBA for that. The following unashamed hack opens the presentation
named in cell A1 of the active sheet, and turns to the slide number in
cell A2.

Sub GotoSlide()
'' Late Binding
'' Presentation name and path in cell A1
'' Slide number in cell A2

Dim pApp As Object ' PowerPoint.Application
Dim pPreso As Object ' PowerPoint.Presentation
Dim pSlide As Object ' PowerPoint.Slide
Dim sPreso As String ' Presentation Fullname
Dim iSlide As Integer ' Slide Index

sPreso = ActiveSheet.Cells(1, 1).Value
iSlide = ActiveSheet.Cells(2, 1).Value

'' Get active PowerPoint instance
On Error Resume Next
Set pApp = GetObject(, "PowerPoint.Application")
If Err.Number 0 Then
'' PowerPoint isn't running, so open it
Set pApp = CreateObject("PowerPoint.Application")
pApp.Visible = True
End If
On Error GoTo 0

On Error Resume Next
'' get our presentation
Set pPreso = pApp.presentations(sPreso)
If Err.Number 0 Then
'' our presentation isn't open, so open it
Set pPreso = pApp.presentations.Open(Filename:=sPreso)
End If
On Error GoTo 0

'' need to be in PowerPoint normal view
pApp.ActiveWindow.ViewType = 9 ' ppViewNormal
If pPreso.slides.Count = iSlide Then
'' desired slide exists, so open to it
pApp.ActiveWindow.View.GotoSlide Index:=2
End If

'' activate PowerPoint to display the slide
AppActivate pApp.Caption

End Sub

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Charlie A wrote:
Does anyone know an easy way to hyperlink from Excel to a specific
slide (say Slide 59) in a PowerPoint file using the hyperlink
worksheet function. Thanks for your help.

can't test since i uninstalled pp BUT
apparently you CAN go to a slide
within a ppt.. by using the subaddress
(similar to excel)

i think you should read this...
http://www.rdpslides.com/pptfaq/FAQ00162.htm



keepITcool

email : keepitcool chello nl (with @ and .)
homepage: http://members.chello.nl/keepitcool


Jon Peltier wrote:

Charlie -

You can't go to a particular slide from a hyperlink in Excel. You have
to use VBA for that. The following unashamed hack opens the presentation
named in cell A1 of the active sheet, and turns to the slide number in
cell A2.

Thanks for the link, though I couldn't really make sense out of the
subaddress bit. However....

I just read a post by J.E. McGimpsey about hyperlinking to a particular
bookmark in a Word document, and he suggests using the file path and
name followed by # and the bookmark name. So I just tried adding # and
the slide number after the PowerPoint file name, and the link opened
right to that slide. It opened in slideshow view, which I'd probably
never want, but that's how I make use of PowerPoint.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

keepITcool wrote:
can't test since i uninstalled pp BUT
apparently you CAN go to a slide
within a ppt.. by using the subaddress
(similar to excel)

i think you should read this...
http://www.rdpslides.com/pptfaq/FAQ00162.htm



keepITcool

email : keepitcool chello nl (with @ and .)
homepage: http://members.chello.nl/keepitcool


Jon Peltier wrote:


Charlie -

You can't go to a particular slide from a hyperlink in Excel. You have
to use VBA for that. The following unashamed hack opens the presentation
named in cell A1 of the active sheet, and turns to the slide number in
cell A2.

FYI

the # is also used for linking to excel workbooks
as a separator between address(file) and subaddress(sheet!range)


File paths with # will be parsed incorrectly
I always enclose the sheetname in single quotes to avoid probs with
sheetnames that have spaces in them..
and i DO include a space after the # to allow the tooltip to wrap

=hyperlink("d:\folder\path.xls# 'my sheet'!b14")



keepITcool

email : keepitcool chello nl (with @ and .)
homepage: http://members.chello.nl/keepitcool


Jon Peltier wrote:

Thanks for the link, though I couldn't really make sense out of the
subaddress bit. However....

I just read a post by J.E. McGimpsey about hyperlinking to a
particular bookmark in a Word document, and he suggests using the file
path and name followed by # and the bookmark name. So I just tried
adding # and the slide number after the PowerPoint file name, and the
link opened right to that slide. It opened in slideshow view, which
I'd probably never want, but that's how I make use of PowerPoint.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

keepITcool wrote:
can't test since i uninstalled pp BUT
apparently you CAN go to a slide
within a ppt.. by using the subaddress
(similar to excel)

i think you should read this...
http://www.rdpslides.com/pptfaq/FAQ00162.htm



keepITcool

email : keepitcool chello nl (with @ and .)
homepage: http://members.chello.nl/keepitcool


Jon Peltier wrote:


Charlie -

You can't go to a particular slide from a hyperlink in Excel. You
have to use VBA for that. The following unashamed hack opens the
presentation named in cell A1 of the active sheet, and turns to the
slide number in cell A2.

FYI, adding a "#" followed by slide number, does NOT work in Office 2007.


"Jon Peltier" wrote:

Thanks for the link, though I couldn't really make sense out of the
subaddress bit. However....

I just read a post by J.E. McGimpsey about hyperlinking to a particular
bookmark in a Word document, and he suggests using the file path and
name followed by # and the bookmark name. So I just tried adding # and
the slide number after the PowerPoint file name, and the link opened
right to that slide. It opened in slideshow view, which I'd probably
never want, but that's how I make use of PowerPoint.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

keepITcool wrote:
can't test since i uninstalled pp BUT
apparently you CAN go to a slide
within a ppt.. by using the subaddress
(similar to excel)

i think you should read this...
http://www.rdpslides.com/pptfaq/FAQ00162.htm



keepITcool

email : keepitcool chello nl (with @ and .)
homepage: http://members.chello.nl/keepitcool


Jon Peltier wrote:


Charlie -

You can't go to a particular slide from a hyperlink in Excel. You have
to use VBA for that. The following unashamed hack opens the presentation
named in cell A1 of the active sheet, and turns to the slide number in
cell A2.