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

You can try to turn off the Alert in your code

Application.DisplayAlerts = False
' your code to save
Application.DisplayAlerts = True

(I am not absolutely sure it will work in this instance, but try it and you
might like it)...

--
steveB

Remove "AYN" from email to respond
"Ken Loomis" wrote in message
...
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

I think is that the user is getting this message when they click the save
button (save normally). I thought at first that your code could go in the
BeforeSave event but the message is occurring before the beforesave event
fires.

Strange conundrum.

"STEVE BELL" wrote in message
news:hlGxe.12518$Fn4.5037@trnddc06...
You can try to turn off the Alert in your code

Application.DisplayAlerts = False
' your code to save
Application.DisplayAlerts = True

(I am not absolutely sure it will work in this instance, but try it and
you might like it)...

--
steveB

Remove "AYN" from email to respond
"Ken Loomis" wrote in message
...
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

I searched using Google for this phrase:

"This file was create using a latter version of Microsoft Excel"

and evidently, it is a problem with no apparent solution. At least, I
couldn't find a solution at Microsoft.com or any of the dozen or so web site
where others had already asked for help.

I seem to recall that I asked about this here a long time ago but didn't get
a solution then either.

If I could just figure out how to save the "master" file once as an Excel 97
format file, I think I could make this go away, but even that doesn't work.
The file always seems to know that it was originally created with a later
version of Excel.

I guess I could go in and start a new Excel 97 workbook and manually copy
everything over, but that seems so ridiculous.

Again, any other ideas are most welcome.

TIA,
Ken


"William Benson" wrote in message
...
I think is that the user is getting this message when they click the save
button (save normally). I thought at first that your code could go in the
BeforeSave event but the message is occurring before the beforesave event
fires.

Strange conundrum.

"STEVE BELL" wrote in message
news:hlGxe.12518$Fn4.5037@trnddc06...
You can try to turn off the Alert in your code

Application.DisplayAlerts = False
' your code to save
Application.DisplayAlerts = True

(I am not absolutely sure it will work in this instance, but try it and
you might like it)...

--
steveB

Remove "AYN" from email to respond
"Ken Loomis" wrote in message
...
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

Open the file in Excel 97 and save it there ... That's what I did, I have
both versions.

Bill

"Ken Loomis" wrote in message
...
I searched using Google for this phrase:

"This file was create using a latter version of Microsoft Excel"

and evidently, it is a problem with no apparent solution. At least, I
couldn't find a solution at Microsoft.com or any of the dozen or so web
site where others had already asked for help.

I seem to recall that I asked about this here a long time ago but didn't
get a solution then either.

If I could just figure out how to save the "master" file once as an Excel
97 format file, I think I could make this go away, but even that doesn't
work. The file always seems to know that it was originally created with a
later version of Excel.

I guess I could go in and start a new Excel 97 workbook and manually copy
everything over, but that seems so ridiculous.

Again, any other ideas are most welcome.

TIA,
Ken


"William Benson" wrote in message
...
I think is that the user is getting this message when they click the save
button (save normally). I thought at first that your code could go in the
BeforeSave event but the message is occurring before the beforesave event
fires.

Strange conundrum.

"STEVE BELL" wrote in message
news:hlGxe.12518$Fn4.5037@trnddc06...
You can try to turn off the Alert in your code

Application.DisplayAlerts = False
' your code to save
Application.DisplayAlerts = True

(I am not absolutely sure it will work in this instance, but try it and
you might like it)...

--
steveB

Remove "AYN" from email to respond
"Ken Loomis" wrote in message
...
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

I must be missing something, becasue that doesn't seem to work.

I open the file in Excel 97, click FileSave, but no matter what I do, I
always get the warning dialog.

Do I need to select a specific file format? I thought I had tried several,
but I know I am going around in circles on this by now.

Ken


"William Benson" wrote in message
...
Open the file in Excel 97 and save it there ... That's what I did, I have
both versions.

Bill

"Ken Loomis" wrote in message
...
I searched using Google for this phrase:

"This file was create using a latter version of Microsoft Excel"

and evidently, it is a problem with no apparent solution. At least, I
couldn't find a solution at Microsoft.com or any of the dozen or so web
site where others had already asked for help.

I seem to recall that I asked about this here a long time ago but didn't
get a solution then either.

If I could just figure out how to save the "master" file once as an Excel
97 format file, I think I could make this go away, but even that doesn't
work. The file always seems to know that it was originally created with a
later version of Excel.

I guess I could go in and start a new Excel 97 workbook and manually copy
everything over, but that seems so ridiculous.

Again, any other ideas are most welcome.

TIA,
Ken


"William Benson" wrote in message
...
I think is that the user is getting this message when they click the save
button (save normally). I thought at first that your code could go in the
BeforeSave event but the message is occurring before the beforesave event
fires.

Strange conundrum.

"STEVE BELL" wrote in message
news:hlGxe.12518$Fn4.5037@trnddc06...
You can try to turn off the Alert in your code

Application.DisplayAlerts = False
' your code to save
Application.DisplayAlerts = True

(I am not absolutely sure it will work in this instance, but try it and
you might like it)...

--
steveB

Remove "AYN" from email to respond
"Ken Loomis" wrote in message
...
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