Convert 2003 excel File to 2007 using macro

Question

I have a 2003 excel file, I wish to convert that file to a 2007 excel file in the same location of the excel file and delete the 2003 file.

Please let me know if this is possible

Function ConvertTo2007AndDelete (OldExcelFile As Workbook) As Workbook
     'Code goes here
End Function

Thanks in advance

Aaron Kempf Aaron Kempf · Accepted Answer · 2011-03-18T13:58:29

I use 'Windows Script Host' to delete files, I'm sure that there is an easier way.

but here is all I had to do to take an open 2003 spreadsheet and save it as 2007

ActiveWorkbook.SaveAs Filename:= _
    "C:\Users\Administrator.CLPOINT\Desktop\CSC1.xlsx", FileFormat:= _
    xlOpenXMLWorkbook, CreateBackup:=False