How can I get a file to automatically save as xlNormal?

I have a file in my XLSTART folder that I want to have available to Excel 2002.
When I open Excel 2007 and modify the file, I want to save it as a .xls file so that it is available to 2002.

Is there a convenient way to have 2007 automatically save it as an .xls file? I know I can write a BeforeSave macro to do a .SaveAs xlNormal, but I'm hoping that there is some setting somewhere that will do it automatically.

EDIT: I just discovered that Excel appears to save a file in the same format that it was originally saved in. Sorry for wasting every one's time.

you can change 2007 default file save as option.but that would apply to all workbooks

Hi martindwilson;

Thanks, unfortunately that's not what I need. When I'm working in 2007, I want the file I'm working in to save as a 2007 file. I just don't want my macro file to be saved as 2007 file.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
  ThisWorkbook.SaveAs ThisWorkbook.FullName
End Sub

or

Private Sub Workbook_BeforeClose(Cancel As Boolean)
  ThisWorkbook.SaveAs ThisWorkbook.FullName, xlExcel8
End Sub

or

Private Sub Workbook_BeforeClose(Cancel As Boolean)
  ThisWorkbook.SaveAsCopy ThisWorkbook.FullName, xlExcel8
End Sub

Under Excel Options,Advanced, General, there an option to open all file in:
So maybe you can save your macro workbook in a separate folder and enter it there. If you indicate XLSTART it will open All files in that folder which may not be what you want.

protonLeah;

I want the macro file to be accessed by all instances of Excel whether 2002 or 2007. I just don't want to have it saved in a format that 2002 can't access.

snb;

I'm saving that as a last resort. I was hoping to avoid a macro to do it.
I'm curious. Have you tried this? Wouldn't the "SaveAs" method crash because the filename already exists? I assumed that I would have to SaveAs a filename in a different folder then another SaveAs to put it back into XLSTART.

I'm confused. If you have an .xls file, then just save it. If you have an xlsx or xlsm or xlsb, then you need saveas, but since the file name will not be the same (it will be an .xls) your question seems to be moot?

romperstomper;

I was under the impression that Excel would try to save a file in the default format for the Excel version you're working in. I admit I didn't try it before I asked the question. Now I tried it, and it does appear that Excel saves it in the format that it was originally saved.

I learn something new every day.

Another pointless question.

If you SaveAs, then yes. If you just Save, then it saves in whatever format it was originally. Otherwise I think we'd all have gone mad! (or madder, in my case)
Oh, and if you learn something, then it's not a pointless question.

Pointless was a bad choice of words.