I have the following code in "Workbook-BeforeSave" in my Excel 2010 .xlsm file:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
It works well, except the saved file really isn't in an .xls format. How can I save it as an .xls file? I understand I will loose the macro's etc., I only want the data to remain in the newly created file.