VBA save as .xlsx

[Duckbill32]

Hi everyone,
I am wondering how to open SaveAs dialog box so, that the saving file format would already be preselected as Excel Workbook (.xlsx), even if the original file has different extension.
I can open SaveAs window with this code, but how to preselect the formatting?

Application.Dialogs(xlDialogSaveAs).Show

Thanks!

 

[Legacy 143009]

Like this?

saveWorkbook = Application.Dialogs(xlDialogSaveAs).Show(Arg1:="", Arg2:=51)

 

[Duckbill32]

Like this?

saveWorkbook = Application.Dialogs(xlDialogSaveAs).Show(Arg1:="", Arg2:=51)

Thanks, @Flashbond! I understand it now

 

[Legacy 143009]

Glad it did work! Argument1 is reserved for the file name. So, that you can predefine a file name also.

 

[Duckbill32]

Glad it did work! Argument1 is reserved for the file name. So, that you can predefine a file name also.

Yeah, I figured that out and tried already - it works very well