When I save a workbook, I often get the dialog box warning me that the file
was created with a later version of Excel.

It starts out:

This file was create using a latter version of Microsoft Excel. If you save
this file using Microsoft Excel 97
information created with features in the later version may be lost.

If I click "Yes," the file gets saved, but the dialog always cpomes back.

It's a nuisance for the users and I'd like to make it go away.

The original workbook was created with Excel 2003, but then I had to finish
it on Excel 97 since some of the users would be using that version of Excel
and those with the older version of Excel were getting errors. I got rid of
all those errors and everything except that nuisance dialog box worked
great.

Now, I find I am having to write a routine that will:

collect all the old file names

for each file in this list of files
open each file
correct a misspelling
save the file
close the workbook
delete that file name from the list
next file

I have most everything done and it works well, but it takes some time.

The only problem is that I get that version dialog warning for each file I
save and that dialog has to be answered by the user for every file, which is
not going to work.


So I have two questions about this problem:

1) How can I make that dialog go away for the users?

2) How can I bypass that dialog when I do this automatic correction routine?


Any body have any ideas?

TIA,
Ken