Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-01-2013, 02:38 PM
kisa500 kisa500 is offline Macro to update ole links not working Windows 7 64bit Macro to update ole links not working Office 2010 64bit
Novice
Macro to update ole links not working
 
Join Date: Feb 2013
Posts: 4
kisa500 is on a distinguished road
Default Macro to update ole links not working

I found a macro that is supposed to update ole links in powerpoint but it doesn't seem to be working. Any suggestions?



Original source of macro: http://www.pptfaq.com/FAQ00759_Searc...link_paths.htm

VB Script with my mods:
Code:
Sub ChangeOLELinks()

    Dim oSld As Slide
    Dim oSh As Shape
    Dim sOldPath As String
    Dim sNewPath As String

    ' EDIT THIS TO REFLECT THE PATHS YOU WANT TO CHANGE
    ' Include just the portion of the path you want to change
    ' For example, to change links to reflect that files have moved from
    ' \\boss\p-drive\temp\*.* to
    ' \\boss\Q-drive\temp\*.*
    sOldPath = "c:\Finance Pitch Automation\UK PDL Weekly Ops Pitch\"                                '"\\boss\p-drive\"
    sNewPath = "c:\Finance Pitch Automation\Development\UK PDL Weekly Ops Pitch\"                    ' "\\boss\q-drive\"
    
    On Error GoTo ErrorHandler

    For Each oSld In ActivePresentation.Slides
        For Each oSh In oSld.Shapes
            ' Change only linked OLE objects
            If oSh.Type = msoLinkedOLEObject Then
             '   On Error Resume Next
                ' Verify that file exists
               ' If Len(Dir$(Replace(oSh.LinkFormat.SourceFullName, sOldPath, sNewPath))) > 0 Then
                     oSh.LinkFormat.SourceFullName = Replace(oSh.LinkFormat.SourceFullName, sOldPath, sNewPath)
              '  Else
               '       MsgBox ("File is missing; cannot relink to a file that isn't present")
                End If
             '   On Error GoTo ErrorHandler
            ' End If
        Next    ' shape
    Next    ' slide

  MsgBox ("Done!")

NormalExit:
    Exit Sub
    
ErrorHandler:
    MsgBox ("Error " & Err.Number & vbCrLf & Err.Description)
    Resume NormalExit

End Sub
Reply With Quote
 

Tags
ole links



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to update ole links not working PPT 2010 Update Links Error MichaelinSJ PowerPoint 2 10-03-2012 10:44 AM
Macro to update ole links not working How to set links that automatically update tkelly5446 Project 1 11-17-2010 04:26 AM
mailto links not working in outlook matt_sheehy Outlook 0 07-26-2010 04:11 PM
Macro to update ole links not working Automatic Update of links has been disabled: Kal Excel 1 03-21-2010 09:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:52 PM.


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