Save 2003 as 2007

[kclong]

How do I write a macro that will save a 2003 version of a file (.xls) as a 2007 version (.xlsx)?

 

[VoG]

Perhaps like this

Sub test()
With ActiveWorkbook
    .SaveAs Filename:= .FullName & "x", FileFormat:=51
End With
End Sub

 

[rs2k]

I could be wrong but I don't think 2003 has that functionality. 2007 can read a 2003 file though.

Colin

 

[kclong]

I have 2007 version of excel, and I know that it can read 2003 files. I want to actually open a 2003 file and re-save it as a 2007 version with a macro.

The code below simply makes it say .xlsx but it doesn't actually save it as a 2007 file.

Any other thoughts? Thanks.