![]() |
#1
|
||||
|
||||
![]()
I am trying to making macro for doing specific task
Code:
Sub Fees() ' ' Fees Macro ' ' With Selection.Find .Text = "," .Replacement.Text = "" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = False .MatchWholeWord = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With Selection.Find.Execute Replace:=wdReplaceAll With Selection.Find .Text = "US ([0-9]{5} )" .Replacement.Text = "US RE\1" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = False .MatchWholeWord = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With Selection.Find.Execute Replace:=wdReplaceAll Selection.Find.ClearFormatting Selection.Find.Replacement.ClearFormatting With Selection.Find .Text = "US ([0-9]{5} )" .Replacement.Text = "US RE\1" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = False .MatchWholeWord = False .MatchAllWordForms = False .MatchSoundsLike = False .MatchWildcards = True End With Selection.Find.Execute Replace:=wdReplaceAll Selection.Find.ClearFormatting With .Find .Text = "US [R3-9][0-9E]{6}" .Replacement.Text = "US RE\1" .Forward = True .Wrap = wdFindStop .Format = False .MatchWildcards = True .Execute End With Do While .Find.Found End With Selection.Copy Documents.Add DocumentType:=wdNewBlankDocument Selection.PasteAndFormat (wdFormatPlainText) Selection.Find.ClearFormatting Selection.Find.Replacement.ClearFormatting With Selection.Find .Text = "US " .Replacement.Text = "" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = False .MatchWholeWord = False .MatchAllWordForms = False .MatchSoundsLike = False .MatchWildcards = True End With Selection.Find.Execute Replace:=wdReplaceAll ChangeFileOpenDirectory "C:\Users\rahulkumar.patel\Desktop\" ActiveDocument.SaveAs2 FileName:="i.txt", FileFormat:=wdFormatText, _ LockComments:=False, Password:="", AddToRecentFiles:=True, WritePassword _ :="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:=False, _ SaveNativePictureFormat:=False, SaveFormsData:=False, SaveAsAOCELetter:= _ False, Encoding:=1252, InsertLineBreaks:=False, AllowSubstitutions:=False _ , LineEnding:=wdCRLF, CompatibilityMode:=0 Selection.Find.ClearFormatting Selection.Find.Replacement.ClearFormatting With Selection.Find .Text = "US " .Replacement.Text = "" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = False .MatchWholeWord = False .MatchAllWordForms = False .MatchSoundsLike = False .MatchWildcards = True End With ActiveWindow.Close End Sub The Problem is I don't know where to start loop function. Source file is at here: https://sites.google.com/site/rtsk2015/fo Sr.docx |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
konopca | Word VBA | 5 | 02-20-2014 02:34 PM |
![]() |
khalidfazeli | Excel | 2 | 02-06-2013 09:38 AM |
![]() |
jperez84 | Word VBA | 24 | 09-20-2012 11:34 AM |
![]() |
jperez84 | Word VBA | 10 | 09-19-2012 04:48 PM |
Trying to find and copy all headings at the same time | WaltR | Word | 7 | 08-21-2012 03:12 PM |