How to save file with correct file extension, .xls or .xlsx?

Hey all,

Question, how can I save worksheet from existing workbook as a new workbook with extension .xls or .xlsx depending on the version of Excel on which the original was opened and no matter the extension of original?

my code that I was trying to create all above does not work, because even if I am using Excel 2007, 2010 or 2013 it will still be saving only as .xls.

Please help

Please Login or Register  to view this content.

Ok I have managed to change the code a bit and works, but now it saves the new template in Compatibility Mode in Excel 2007, 2010 and 2013.

What should I do?

Here is my new code

Please Login or Register  to view this content.

I don't know what's going wrong off the top of my head, but have you looked at GetSaveAsFilename and SaveAs method documentation as regards the FileFilter param and FileFormat param?

I forget which ones are for which Method.