![]() |
#13
|
||||
|
||||
![]()
That would be simpler
Code:
Option Explicit Sub SaveAs() ' ' SaveAs Macro ' ' Dim sName As String, aCC As ContentControl Dim sFilename As String, sNow As String, sPath As String Dim i As Integer sPath = Environ("USERPROFILE") & Chr(92) & "Desktop\" For Each aCC In ActiveDocument.ContentControls If aCC.Title = "Subject" Then i = i + 1 Exit For End If Next aCC If i = 0 Then MsgBox "The 'Subject' Content Control is missing", vbCritical Exit Sub End If For Each aCC In ActiveDocument.ContentControls If aCC.Title = "Subject" Then If aCC.ShowingPlaceholderText = True Then MsgBox "Complete the 'Subject' field!", vbCritical aCC.Range.Select Exit Sub End If sName = Trim(aCC.Range.Text) sName = Replace(sName, Chr(32), "") End If sNow = Format(Now, "dd-mm-yy_HHMMSS") sFilename = sName & "_" & sNow & ".docx" ActiveDocument.SaveAs2 FileName:=sPath & sFilename, FileFormat:=wdFormatXMLDocument Next aCC Set aCC = 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 | Thread Starter | Forum | Replies | Last Post |
How to save Word file by field name as filename using VBA button? | TribeBuckeyeFan | Word VBA | 4 | 02-02-2017 05:58 AM |
![]() |
chemtoli | Word VBA | 5 | 01-25-2017 08:06 AM |
Save and rename attachments from ZIP FILE | AndyDDUK | Outlook | 1 | 03-03-2016 12:32 AM |
![]() |
intelli | Excel | 3 | 03-27-2014 11:53 PM |
![]() |
d4okeefe | Word VBA | 4 | 05-23-2013 09:35 AM |