Today’s author is Ron de Bruin , an Excel MVP. You can find more useful tips and links to Excel add-ins at his website: http://www.rondebruin.nl/ You see a lot of old SaveAs code that does not specify the FileFormat parameter. In Excel versions before Excel 2007, code without this parameter will not cause too many problems because Excel will use the current FileFormat of the existing file -- and the default FileFormat for new files is a normal workbook. But because there are so many new file formats
Read More...
Read the complete post at http://blogs.msdn.com/excel/archive/2009/07/07/use-the-vba-saveas-method-in-excel-2007.aspx
Posted
Jul 07 2009, 03:39 PM
by
Microsoft Excel