Printable View
I have an excel 97 file that was mistakenly opened and saved in xl2002. No changes were done to the file, it just ran the save command.
Now when I open it in 97, on each save I get a box saying it was saved in another version of excel and asking if I want to lose my changes, etcs.. How do I tell Excel that this is an Excel 97 file again and not an Excel 02 file?
Hey Fiddler, can't you do a save as and select 97 format file type
instead of a regular save?
You'd think that would work, wouldn't you?
Tried two approaches - both failed
From within Excel 02, opened my file and then Save As, file type Excel 97.
First got an error that said I was unable to save to this file format with a locked VBA module. So I unlocked my VBA module, and tried to save again as Excel 97 format, got a "Document Not Saved" information error screen pop up.
Then I tried from within Excel 97, and forced the Format to Excel 97 file type. Up comes my warning saying that this file is from a later version and that data will be lost if I continue. I continue anyway. So in theory, this should be in 97 format, but if I try to save again or to reopen the file, I get the ever so annoying message that this file is from a later version and that data will be lost if I continue.
So my question remains - are their any properties or flags within the file that determine the file type? Anyone have any other approaches to this?
Would it be possible to create a new Excel 97 workbook and
copy/recreate the 2002 version. This would be an original 97
version workbook with the same contents as the mistake 2002
version workbook. Then open with 2002 and make some changes
and save as 97 version format.
Not too sure on what flags there may be to designate the version
differences.
In hindsight, maybe you could add a safty check to make sure
they are not allowed to save as 2002?
HTH
If I knew what the 2002 flags were, I would cut/paste from 02 workbook into an XL97 workbook.
If I paste code or formatting that is 02 only, then I will only get the same result.
Actually, I decided my course of action - restore from backup and redo the changes that I've done over the past week. That way I am confident that I did not miss something that would adversely effect the performance of my program.
And as to the stop save as 2002 idea, easy to code for 02, but the same code will generate an error under 97 as the file type did not exist then.
btw: cool news to share. just discovered that my software company was recipient of a Innovation leader of the year award for our area because of our latest software release. Fun stuff.
Congradulations!
What about checking if being saved as 97 then let the save
happen? Else it doesn't matter what version, just deny it.
PS. do we get any honerable mention in your programs credits? JK.
:)