Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-09-2012, 06:41 AM
ziba ziba is offline Edits links to Excel file in PowerPoint Windows 7 64bit Edits links to Excel file in PowerPoint Office 2010 64bit
Novice
Edits links to Excel file in PowerPoint
 
Join Date: Mar 2011
Posts: 12
ziba is on a distinguished road
Question Edits links to Excel file in PowerPoint

Hi All, can anyone help?

I have a PowerPoint document with a number of linked Excel files. How can I tell which links belong to which slide?



Many thanks.
Reply With Quote
  #2  
Old 01-09-2012, 07:13 AM
JohnWilson JohnWilson is offline Edits links to Excel file in PowerPoint Windows 7 64bit Edits links to Excel file in PowerPoint Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,912
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default

As you may know you can see and edit the links by going to File > Info > Edit Links (right pane)

This won't tell you which slide the links are on though. I think code is the only way to get that.

Here's an example

Sub list_links()
Dim oshp As Shape
Dim osld As Slide
Dim strReport As String
For Each osld In ActivePresentation.Slides
For Each oshp In osld.Shapes
If oshp.Type = msoLinkedOLEObject Then
If InStr(oshp.OLEFormat.ProgID, "Excel") > 0 Then
strReport = strReport & "On Slide " & osld.SlideIndex & _
"> Link = " & oshp.LinkFormat.SourceFullName & vbCrLf
End If
End If
Next oshp: Next osld
If strReport <> "" Then
MsgBox strReport
Else
MsgBox "No Excel links"
End If
End Sub

Dont know how to use this? Go Here!
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
  #3  
Old 01-09-2012, 07:55 AM
ziba ziba is offline Edits links to Excel file in PowerPoint Windows 7 64bit Edits links to Excel file in PowerPoint Office 2010 64bit
Novice
Edits links to Excel file in PowerPoint
 
Join Date: Mar 2011
Posts: 12
ziba is on a distinguished road
Default

Thanks for your reply - I will try the code.
Reply With Quote
  #4  
Old 01-09-2012, 08:12 AM
ziba ziba is offline Edits links to Excel file in PowerPoint Windows 7 64bit Edits links to Excel file in PowerPoint Office 2010 64bit
Novice
Edits links to Excel file in PowerPoint
 
Join Date: Mar 2011
Posts: 12
ziba is on a distinguished road
Default

You are amazing! The code is perfect!
Reply With Quote
  #5  
Old 01-09-2012, 08:48 AM
JohnWilson JohnWilson is offline Edits links to Excel file in PowerPoint Windows 7 64bit Edits links to Excel file in PowerPoint Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,912
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default

Glad it worked for you!
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Edits links to Excel file in PowerPoint Have Powerpoint dynamically update from an excel or other file? oshkosh PowerPoint 3 04-05-2016 06:10 AM
PowerPoint removes urlencoding on links kamcknig PowerPoint 0 08-10-2011 08:50 AM
saving a mail merged document after the user edits it. kosh2 Mail Merge 0 08-05-2011 03:35 AM
Powerpoint 2010 losing links to excel Hans_b PowerPoint 0 07-12-2011 04:19 AM
Edits links to Excel file in PowerPoint Run Excel file with Powerpoint minimized agios59 PowerPoint 1 11-16-2010 08:58 AM

Other Forums: Access Forums

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


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