Convert 2003 excel File to 2007 using macro

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

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