Thanks
Tom
Assuming you first rename the image files to eliminate the space there also,
this should help:
Show me the link and let me edit it
http://www.pptfaq.com/FAQ00433.htm
-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Live and in personable in the Help Center at PowerPoint Live
Sept 21-24, San Diego CA, USA
www.pptlive.com
So I would have to use code similar to your reference to change all the
linked names to remove spaces and also change all the file names to remove
spaces.
Thanks
Tom
Not that I know of, at lest not for normal image links (insert, picture from file,
choose link). For linked objects, spaces might indeed cause trouble.
> So I would have to use code similar to your reference to change all the
> linked names to remove spaces and also change all the file names to remove
> spaces.
Other way around. You'd need to change the filenames first; PowerPoint won't let
you link to a file that's not there.
Public Sub FixFileLinks()
Dim Logger As Integer
Logger = FreeFile
Open "Logger.txt" For Append As Logger
Dim SL As Slide
Dim SlideCount As Integer
Dim LinkCount As Integer
Dim LinksFixed As Integer
SlideCount = 0
LinkCount = 0
LinksFixed = 0
For Each SL In ActivePresentation.Slides
Dim SP As Shape
For Each SP In SL.Shapes
If (SP.Type = msoLinkedPicture) Then
LinkCount = LinkCount + 1
With SP
If InStr(1, .LinkFormat.SourceFullName, " ") > 0 Then
LinksFixed = LinksFixed + 1
Dim NewName As String
Dim OldName As String
OldName = .LinkFormat.SourceFullName
NewName = .LinkFormat.SourceFullName
NewName = Replace(NewName, " ", "_", 1)
Write #Logger, " OldName " & OldName
Write #Logger, " NewName " & NewName
Write #Logger, " ========="
Name OldName As NewName
.LinkFormat.SourceFullName = NewName
End If
End With
End If
Next SP
SlideCount = SlideCount + 1
Next SL
Write #Logger, " Slide count " & SlideCount
Write #Logger, " Link Count " & LinkCount
Write #Logger, " Links Fixed " & LinksFixed
Close Logfile
End Sub