Microsoft Office Forums - View Single Post - Drawing Button With VBA To Rename File And Save

Thread: Drawing Button With VBA To Rename File And Save

View Single Post

Old

10-27-2022, 04:33 AM

gmayor

gmayor is offline

gmayor uses Windows 10

Windows 10 gmayor uses Office 2019

gmayor uses Office 2019

Office 2019

Expert

Join Date: Aug 2014

Posts: 4,138

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

Default

Sorry. My fault.

Change the end of the macro as follows:

Code:

        sFilename = sName & "_" & sNow & ".docm"
    Next aCC
    ActiveDocument.SaveAs2 FileName:=sPath & sFilename, FileFormat:=wdFormatXMLDocumentMacroEnabled
    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

Reply With Quote