![]() |
|
|
|
#1
|
||||
|
||||
|
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 |
|
#2
|
|||
|
|||
|
Thanks. Had to change your "Next aCC" line to above the ActiveDocument.SaveAs2 line and then it worked. It was saving multiple files or if I didn't fill in the subject then it would have the prompt pop up but it would also save the file without a name of the company in the file name since subject wasn't filled out.
Thank you very much for your help with this. You just made life a lot easier for my coworkers. Take care. |
|
#3
|
|||
|
|||
|
Sorry have one more question. I wanted to change the sPath from the desktop to our network G
rive in one of the folders. When I replaced the entire sPath to this:sPath = "G:\WP61" The file saved only as far as the root of the G rive and also it did something weird to the file name. It put the G rive folder name that I wanted the file to be saved in, in front of the person's name. I did a test with the name John Doe and this is the file name it generated:WP61Doe,John_10-28-2022_093118.docx |
|
|
|
Similar Threads
|
||||
| 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 |
How to save Word file by field name as filename using VBA button?
|
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 |
Have to rename file every time to save workbook
|
intelli | Excel | 3 | 03-27-2014 11:53 PM |
Rename Document & Save
|
d4okeefe | Word VBA | 4 | 05-23-2013 09:35 AM |