Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 11-26-2014, 05:11 PM
macropod's Avatar
macropod macropod is offline Return value of StyleRef n in VBA variable Windows 7 64bit Return value of StyleRef n in VBA variable Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Try:
Code:
Sub Demo()
Dim i As Long, Rng As Range, StrAltTxt As String
With ActiveDocument
  'Loop through all inlineshapes
  For i = 1 To .InlineShapes.Count
    'Point our range to the start of the document
    Set Rng = .Range(0, 0)
    With .InlineShapes(i)
      'Point the end our range to the start of the inlineshape
      Rng.End = .Range.Start
      With Rng
        'Look backwards for a Heading 4
        With .Find
          .Text = ""
          .ClearFormatting
          .Replacement.Text = ""
          .Replacement.ClearFormatting
          .Format = True
          .Style = wdStyleHeading4
          .Forward = False
          .Wrap = wdFindStop
          .Execute
        End With
        If .Find.Found = True Then
          'If we found a Heading 4, get the text, minus the paragraph end
          With .Duplicate
            .End = .End - 1
            StrAltTxt = .Text
          End With
        End If
      End With
      'Add the Heading 4 text as the Alternative Text
      .AlternativeText = StrAltTxt
      .Title = ""
    End With
  Next
End With
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 

Tags
find & replace



Similar Threads
Thread Thread Starter Forum Replies Last Post
Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge Berryblue Mail Merge 1 11-13-2014 05:36 PM
Return value of StyleRef n in VBA variable Run-time error 91 object variable or with block variable not set JUST ME Word VBA 4 03-25-2014 06:56 AM
Return value of StyleRef n in VBA variable object variable or with block variable not set MJP143 Excel 1 02-11-2013 05:07 AM
Return value of StyleRef n in VBA variable Run-time error '91': Object variable or With block variable not set tinfanide Excel Programming 2 06-10-2012 10:17 AM
Return value of StyleRef n in VBA variable Include URL in StyleRef? profliz Word 3 11-07-2011 09:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:19 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