workbook save as -vba

[lezawang]

Hi
I want to save as a workbook so I wrote the code below. It works fine, it gives me the window below which is save as window

but when I click No (so I can pick macro enable file), I get this error message

I know I am not following the syntax of Save as, but it used to work just fine. Any idea would be appreciated very much.

Sub myworkbook()
    'save
    Workbooks(1).Save
    'save as
    Workbooks(1).SaveAs ("hello.xlsm")
End Sub

 

[Fluff]

Try

Workbooks(1).SaveAs "hello.xlsm", 52

 

[lezawang]

Thank you, works fine now.

 

[Joe4]

When you want to save in any format other than the default xlsx, you need to designate the file format.
See here: https://docs.microsoft.com/en-us/office/vba/api/excel.workbook.saveas

If you look at the link in the File Format argument, you will get this list (and you can see what "52" represents):
https://docs.microsoft.com/en-us/office/vba/api/excel.xlfileformat