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.
Bookmarks