VBA To Save As XLSX

This is also related to below queries:

1. excel vba save as xlsm
2. excel vba save copy as xlsx
3. fileformat:=xlopenxmlworkbook
4. fileformat:=xlnormal
5. activeworkbook.saveas filename
6. vba savecopyas

The Code:

---

ActiveWorkbook.SaveAs Filename:="Path\FileName.xlsx", FileFormat:=xlOpenXMLWorkbook, Password:="123", WriteResPassword:="", ReadOnlyRecommended:=True, CreateBackup:=False

---

Where:

• FileFormat:='xlOpenXMLWorkbook' or 'xlOpenXMLWorkbookMacroEnabled'
• Password:="YourPassword" or "" if no password
• WriteResPassword:="YourPassword" or "" if no password
• ReadOnlyRecommended:=True or False
• CreateBackup:=True or False