If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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.
|
#2
|
|||
|
|||
Hyperlink from Excel to a specific slide in PowerPoint
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. |
#3
|
|||
|
|||
Hyperlink from Excel to a specific slide in PowerPoint
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. |
#4
|
|||
|
|||
Hyperlink from Excel to a specific slide in PowerPoint
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. |
#5
|
|||
|
|||
Hyperlink from Excel to a specific slide in PowerPoint
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. |
#6
|
|||
|
|||
Hyperlink from Excel to a specific slide in PowerPoint
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking PowerPoint Chart to Excel Data | Kevin T | Powerpoint | 1 | June 15th, 2004 07:44 PM |
Inserting Excel into PowerPoint | [email protected] | Powerpoint | 1 | June 1st, 2004 07:12 PM |
Hyperlink between excel 2002 & excel 2000 | Sue | Worksheet Functions | 0 | January 29th, 2004 05:30 AM |