I have macros where I can save a file as Excel 2007 but I need to update those mascros in vba to save the file as Excel 2010. Below is what I currently have.
Dim FName As String
FName = Application.GetSaveAsFilename(FileFilter:="Excel 97-2003 Workbook (*.xls),*.xls")
ActiveWorkbook.SaveAs Filename:=FName, FileFormat:=xlExcel8

How do I change this to make it save as Excel 2010, xlsx?

thanks

Mike