![]() |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#2
|
||||
|
||||
|
I am not sure what the relevance of the attached document is as it is already named with the number, but the following will do the job:
Code:
Sub SavePolicyDoc()
Dim orng As Range
Dim vNumber As Variant
Dim strText As String
Dim bFound As Boolean
Const strPath As String = "" 'Put the folder path here e.g. "C:\Path\"
Set orng = ActiveDocument.Range
With orng.Find
Do While .Execute(FindText:="Policy number - [0-9]{1,}", MatchWildcards:=True)
strText = orng.Text
bFound = True
vNumber = Split(strText, "-")
ActiveDocument.SaveAs Filename:=strPath & Trim(vNumber(UBound(vNumber))) & ".docx"
Exit Do
Loop
If Not bFound Then MsgBox "The policy number was not found"
End With
Set orng = Nothing
End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Macro to rename multiple Word file with same suffix | ozil61 | Word VBA | 2 | 05-06-2014 07:36 AM |
How to specify Document Title from the body of my Document
|
SymphonyTomorrow | Word | 9 | 08-05-2013 05:31 PM |
Rename Document & Save
|
d4okeefe | Word VBA | 4 | 05-23-2013 09:35 AM |
How to import Word Style Headings and body text into Excel
|
antztaylor | Excel | 5 | 11-08-2012 09:54 PM |
Advancing Paragraph Numbers in Merge Document Body
|
Wyskers | Mail Merge | 1 | 11-30-2011 04:46 AM |