VBA code to save spreadsheet as xls

Hi All

I've written a macro that chops up a bunch of data and then creates a report before exporting it. All works as it should on my machine.

However, my customer requires the files to be saved as "Excel Workbook" not "Excel 97-2003 Workbook"

They are using Excel 2016, I'm using Excel for MS 365 MSO

I've tried saving file format as xlExcel8, 56 etc but all of them save down as Excel-97-2003 Workbook

Code I've used is:

ActiveWorkbook.SaveAs Filename:=RepName, FileFormat:=56, CreateBackup:=False

Is someone able to confirm how I can save as xls but not 97-2003? Or am I missing something bigger?

Thanks very much
Blokeyfella

Excel Workbook is .xlsx not .xls

try FileExtStr = ".xlsx": FileFormatNum = 51

Gaaaah!!!
What an idiot.

Apologies and thanks very much - combination of setting .xls in the RepName variant and also using the wrong fileformat number

Schoolboy!

Appreciate the replies, thanks very much!!