Saving Excel file as .xls in Excel 2007

[Donal28]

Hi All

I'm looking to save an excel file as a .xls file in Excel 2007. I have the following line of code in the macro which will save the file as a .xlsx file(because its beeen opened in Excel 2007) but as the macro opens and closes numerous files it produces never ending imcompatability errors when saving. Can the code below be amended to save as a .xls file

wkbTarget.Close savechanges:=True

any help on this would be very much appreciated

Regards
Donal

 

[Trevor G]

Take a look at this, I simply recorded a macro to use the current workbook to Save as 97 - 2003 format (I recorded and then pressed F12 which is Save as). you should note the version details

Sub Macro1()
'
' Macro1 Macro
'

'
ActiveWorkbook.SaveAs Filename:= _
"C:\Users\Trevor G\Documents\newtest.xls", FileFormat:=xlExcel8, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
End Sub

 

[Richard Schollar]

Hi Donal

Try this:

wkbTarget.SaveAs wkbTarget.Name,FileFormat:=56
wkbTarget.Close SaveChanges:=False

 

[Donal28]

Hi Donal

Try this:

wkbTarget.SaveAs wkbTarget.Name,FileFormat:=56
wkbTarget.Close SaveChanges:=False

Thanks for the reply guys, I think Richards solution is the ine I will opt for

 

[Donal28]

Take a look at this, I simply recorded a macro to use the current workbook to Save as 97 - 2003 format (I recorded and then pressed F12 which is Save as). you should note the version details

Thanks for your help Trevor, I too am a Blues supporter!! Hughton would be a good appointment

 

[Trevor G]

Pleased to read you have a solution that you can work with.

Yes Donal I agree I think Chris will be a good appointment for the Blues but the board must work with him!