word 2013 operation on text

macropod · #1 09-25-2018, 02:21 AM

Try, for example:

Code:

Sub Demo()
Application.ScreenUpdating = False
With ActiveDocument.Range
  With .Find
    .ClearFormatting
    .Replacement.ClearFormatting
    .Text = "[0-9]{1,4} [AB].[DC]."
    .Replacement.Text = ""
    .Forward = True
    .Format = False
    .Wrap = wdFindStop
    .MatchWildcards = True
    .Execute
  End With
  Do While .Find.Found
    If Split(.Text, " ")(1) = "B.C." Then
      .InsertAfter " (chinese year " & Split(.Text, " ")(0) + 2699 & ")"
    ElseIf Split(.Text, " ")(1) = "A.D." Then
      .InsertAfter " (chinese year " & Split(.Text, " ")(0) + 2698 & ")"
    End If
    .Collapse wdCollapseEnd
    .Find.Execute
  Loop
End With
Application.ScreenUpdating = True
End Sub

Note: You'll need to check the correct value to add for B.C. years vs A.D. years, since there was no 0 B.C./A.D.

dogufo · #2 09-25-2018, 03:43 AM

Quote:

Originally Posted by macropod

Try, for example:

Code:

Sub Demo()
Application.ScreenUpdating = False
With ActiveDocument.Range
  With .Find
    .ClearFormatting
    .Replacement.ClearFormatting
    .Text = "[0-9]{1,4} [AB].[DC]."
    .Replacement.Text = ""
    .Forward = True
    .Format = False
    .Wrap = wdFindStop
    .MatchWildcards = True
    .Execute
  End With
  Do While .Find.Found
    If Split(.Text, " ")(1) = "B.C." Then
      .InsertAfter " (chinese year " & Split(.Text, " ")(0) + 2699 & ")"
    ElseIf Split(.Text, " ")(1) = "A.D." Then
      .InsertAfter " (chinese year " & Split(.Text, " ")(0) + 2698 & ")"
    End If
    .Collapse wdCollapseEnd
    .Find.Execute
  Loop
End With
Application.ScreenUpdating = True
End Sub

Note: You'll need to check the correct value to add for B.C. years vs A.D. years, since there was no 0 B.C./A.D.

Thank you very much

so this code can be used with python or how to make it work with word 2013? (Sorry, I am not practical

)

macropod · #3 09-25-2018, 02:12 PM

Quote:

Originally Posted by dogufo

so this code can be used with python or how to make it work with word 2013?

It's a Word macro (which is what you asked for), so it has nothing to do with Python.

For PC macro installation & usage instructions, see: http://www.gmayor.com/installing_macro.htm
For Mac macro installation & usage instructions, see: https://wordmvp.com/Mac/InstallMacro.html

dogufo · #4 09-26-2018, 12:08 AM

thank you very much; it works! even an idiot like me can make it work!

Please, Mr Macropod, because unfortunately I haven´t finished yet

if I don´t aks too much...

could you please change the code in the way that it makes the same "operation" as described above when there is NOT "A.D." after the 4 digit years numbers

So as result I can make 2 macros

tkx very much again from Italy!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automatically duplicate text for word templates (word 2013)	Old	Word	1	04-11-2018 11:25 PM
Changing numerals to red in one operation	oldyeller38	Word	10	04-27-2015 04:09 AM
video operation	tomasball	PowerPoint	0	10-29-2010 03:06 PM
Associated operation	ECPL_3	Excel	2	10-14-2010 05:29 PM
Basic operation of Excel not working!	praveen_p	Excel	2	04-23-2009 10:21 AM