Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 10-15-2015, 02:57 AM
JohnWilson JohnWilson is offline Creating a list of Hyperlinks in PPT deck Windows 7 64bit Creating a list of Hyperlinks in PPT deck Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,914
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default

I'm guessing you would like a printable list from Steve's code?

here's how to get that:

Code:
Sub ShowMeTheHyperlinksPrintable()
' Lists the slide number, shape name and address
' of each hyperlink
Dim oSl As Slide
Dim oHl As Hyperlink
Dim strReport As String
Dim ifilenum As Integer
Dim filepath As String
filepath = Environ("USERPROFILE") & "\Desktop\links.txt"
For Each oSl In ActivePresentation.Slides
For Each oHl In oSl.Hyperlinks
If oHl.Type = msoHyperlinkShape Then
strReport = strReport & "HYPERLINK IN SHAPE" _
& vbCrLf _
& "Slide: " & vbTab & oSl.SlideIndex _
& vbCrLf _
& "Shape: " & oHl.Parent.Parent.Name _
& vbCrLf _
& "Address:" & vbTab & oHl.Address _
& vbCrLf _
& "SubAddress:" & vbTab & oHl.SubAddress & vbCrLf
Else
' it's text
strReport = strReport & "HYPERLINK IN TEXT" _
& vbCrLf _
& "Slide: " & vbTab & oSl.SlideIndex _
& vbCrLf _
& "Shape: " & oHl.Parent.Parent.Parent.Parent.Name _
& vbCrLf _
& "Address:" & vbTab & oHl.Address _
& vbCrLf _
& "SubAddress:" & vbTab & oHl.SubAddress & vbCrLf
End If
Next ' hyperlink
Next ' Slide
ifilenum = FreeFile
Open filepath For Output As ifilenum
    Print #ifilenum, strReport
    Close ifilenum
  Call Shell("Notepad.exe " & filepath, vbNormalNoFocus)
End Sub
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
 

Tags
hyperlinks, review



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to put LOTS of pictures into ppt deck - 1 per slide Mmitch799 PowerPoint 1 09-24-2015 04:38 AM
Master Slide Deck creb1099 PowerPoint 2 11-20-2013 07:37 AM
Creating a list of Hyperlinks in PPT deck How to keep hyperlinks when creating a table of contents Abacaxi Word 3 04-18-2012 12:24 AM
Creating a list of Hyperlinks in PPT deck Mac: Problem creating hyperlinks cpm Word 4 04-13-2011 06:25 AM
Creating a list of Hyperlinks in PPT deck Creating Hyperlinks alicein1derville Excel 5 02-08-2009 10:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:00 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft