Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-09-2020, 06:57 AM
djced djced is offline Delete text between 'from' 'to' text strings Windows XP Delete text between 'from' 'to' text strings Office 2007
Novice
Delete text between 'from' 'to' text strings
 
Join Date: Jan 2020
Posts: 5
djced is on a distinguished road
Default

Quote:
Originally Posted by gmayor View Post
Hmmm. The following will do what you ask, however if you delete the text block this will affect the second part because of text flow:


Code:
Sub Macro1()
Dim oRng As Range
Dim sText1 As String, sText2 As String
    sText1 = "service on the seller"
    sText2 = "service on the Buyer"
    Set oRng = ActiveDocument.Range
    If InStr(1, oRng, sText1) = 0 Then
        MsgBox sText1 & " not found"
        GoTo lbl_Exit
    End If
    If InStr(1, oRng, sText2) = 0 Then
        MsgBox sText2 & " not found"
        GoTo lbl_Exit
    End If
    With oRng
        .Start = .Start + InStr(oRng, sText1) - 1
        .End = .Start + InStr(oRng, sText2) + Len(sText2)
        .Text = ""
    End With
lbl_Exit:
    Set oRng = Nothing
    Exit Sub
End Sub

Sub Macro2()
Dim oRng As Range
Dim sText1 As String
    sText1 = "removal Slip"
    Set oRng = ActiveDocument.Range
    If InStr(oRng, sText1) > 0 Then
        With oRng
            .Start = .Start + InStr(oRng, sText1) - 1
            .Collapse 1
            .Select
        End With
        ActiveDocument.Bookmarks("\page").Range.Delete
    Else
        MsgBox sText1 & " not found"
    End If
lbl_Exit:
    Set oRng = Nothing
    Exit Sub
End Sub
Thank you very much for this real quick solution. This is where the forum and the legends help the novice like us...!
Reply With Quote
Reply

Tags
delete page, delete text between, from to text strings



Similar Threads
Thread Thread Starter Forum Replies Last Post
Extracting Specific Text Strings PWH68 Word VBA 6 10-08-2019 02:07 AM
Locating/deduping similar but not identical text strings strodden Excel 2 06-25-2018 10:37 AM
Delete text between 'from' 'to' text strings Renaming several strings of text by their pattern noname91 Word 10 01-05-2017 05:46 PM
how do I search the content of excel files for text strings soren Excel 2 03-19-2015 09:42 AM
Delete text between 'from' 'to' text strings VBA to copy bookmark-hyperlinks to plain text strings Marrick13 Word 2 04-29-2012 05:12 AM

Other Forums: Access Forums

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