lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I opened a new workbook and wrote the code below in a module and tried to run it but got run time error telling me I need to change the extension? any help would be appreciated thank you.
I opened a new workbook and wrote the code below in a module and tried to run it but got run time error telling me I need to change the extension? any help would be appreciated thank you.
Code:
Sub wk_save()
Application.DisplayAlerts = False
Workbooks(1).SaveAs Filename:="hello.xlsm"
Application.DisplayAlerts = True
End Sub