Excel 2007 : can I force xl2007 to save in .xls format

I don't know what you're trying to do.

I'm trying to force the file to be saved in .xls format.

We have several people collaborating on the file, some of whom use Excel 2007 and some who use 2003. Sometimes, despite telling them not to, and despite the file being opened in compatibility mode, the people updating the file save it in Excel 2007 format.

This causes several headaches:

1) The spreadsheet relies heavily on behind-the-scenes macros. They are stripped out when saved in Excel 2007 format, rendering the updated file practically useless.

2) The converters that allow Excel 2007 files to be read into Excel 2003 do not work reliably for us.

Thus, any time a save is attempted, whether via menu command save/save as, or because an unsaved file is being closed, I want to make sure the file is being saved in its original Excel 2003 format (.xls).

I've got the save/save as working but there is still the quirk described above when closing an unsaved file.

Again,

If you want to ensure that there is always a post-review copy in xls format by the original file name, then store the original workbook name and path (FullName property) in a public variable in the Open event, and save by that name in addition to whatever is the user is doing in the Save event. You could also save as an xlsm in every save as well.