Data Export Macro works in Excel 2013 but not Excel 2007

Try testing for which version is being used with

Application.Version

and have two versions of the saveas line depending on the application version.

Try recording a saveas in 2007 to get the correct syntax.