Word VBA: SaveAs2

macropod · #1 04-17-2012, 10:25 PM

Hi tinfanide,

Try this version:

Code:

Sub Test()
Dim Rng As Range, Str1 As String, Str2 As String
With ThisDocument
  With .Content
    With .Find
      .ClearFormatting
      .MatchWildcards = True
      .Text = "The Principal"
      .Execute
    End With
    If .Find.Found Then
      Set Rng = .Duplicate.Paragraphs.Last.Next.Range
      With Rng
        While Not .Characters.Last Like "[a-z]"
          .End = .End - 1
        Wend
        Str1 = Trim(.Text)
      End With
    End If
  End With
  With .Content
    With .Find
      .ClearFormatting
      .MatchWildcards = True
      .Text = "RE: [!13]@^13"
      .Execute
    End With
    If .Find.Found Then
      Set Rng = .Duplicate
      With Rng
        While Not .Characters.Last Like "[a-z]"
          .End = .End - 1
        Wend
        .Start = .Start + 4
        Str2 = Trim(.Text)
      End With
    End If
  End With
  MsgBox .Path & "\" & Str1 & " " & Str2
  '.SaveAs2 FileName:=ThisDocument.Path & "\" & Str1 & " " & Str2, FileFormat:=wdFormatDocumentDefault
End With
End Sub

if you get a message box with the correct contents, you can delete that line and uncomment the next line.

tinfanide · #2 04-18-2012, 04:47 AM

Quote:

Originally Posted by macropod

Hi tinfanide,

Try this version:

Code:

Sub Test()
Dim Rng As Range, Str1 As String, Str2 As String
With ThisDocument
  With .Content
    With .Find
      .ClearFormatting
      .MatchWildcards = True
      .Text = "The Principal"
      .Execute
    End With
    If .Find.Found Then
      Set Rng = .Duplicate.Paragraphs.Last.Next.Range
      With Rng
        While Not .Characters.Last Like "[a-z]"
          .End = .End - 1
        Wend
        Str1 = Trim(.Text)
      End With
    End If
  End With
  With .Content
    With .Find
      .ClearFormatting
      .MatchWildcards = True
      .Text = "RE: [!13]@^13"
      .Execute
    End With
    If .Find.Found Then
      Set Rng = .Duplicate
      With Rng
        While Not .Characters.Last Like "[a-z]"
          .End = .End - 1
        Wend
        .Start = .Start + 4
        Str2 = Trim(.Text)
      End With
    End If
  End With
  MsgBox .Path & "\" & Str1 & " " & Str2
  '.SaveAs2 FileName:=ThisDocument.Path & "\" & Str1 & " " & Str2, FileFormat:=wdFormatDocumentDefault
End With
End Sub

if you get a message box with the correct contents, you can delete that line and uncomment the next line.

Yes. Thanks for the codes.
With a quite careful look at them, I notice ya've used two

Code:

With .Content
End With

to resolve the problem raised by me last post.

Meanwhile, I'm using

Code:

.Find.Wrap = wdFindContinue

to resolve the problem where the find result keeps the first one, not continues with the subsequent one.

Code:

Sub Macro1()

Dim Str1 As String, Str2 As String
Dim Rng As Range

With ThisDocument
    With .Content

        With .Find
            .ClearFormatting
            .MatchWildcards = True
            .Execute FindText:="The Principal"
        End With
        If .Find.Found Then
            Set Rng = .Duplicate.Paragraphs.Last.Next.Range
            With Rng
                While Not .Characters.Last Like "[a-z]"
                    .End = .End - 1
                Wend
                Str2 = .Text
            End With
        End If
   
        With .Find
            .ClearFormatting
            .MatchWildcards = True
            .Wrap = wdFindContinue
            .Execute FindText:="RE: [!13]@^13"
        End With
        If .Find.Found Then
            Set Rng = .Duplicate
            With Rng
                While Not .Characters.Last Like "[a-z]"
                    .End = .End - 1
                Wend
                .Start = .Start + Len("RE: ")
                Str1 = .Text
            End With
        End If

    End With
End With

Debug.Print Str1 & " " & Str2

End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word Visual Basic error - run time error 504	crazymorton	Word	11	01-13-2012 04:32 AM
Microsoft office 2010 error 2908 and error 1935 !!!!!!heeeeellpppp!!!!!!!!!	bennypryde	Office	1	01-05-2012 03:33 PM
Ms Word Error	manesh	Word	1	05-28-2010 07:26 AM
Runtime error 5487 - Word cannot complete the save to to file permission error	franferns	Word	0	11-25-2009 05:35 AM
Receive error cannot open this form because an error occurred in BCM 2007	bornhusker	Outlook	0	06-01-2009 10:28 AM