I've written a VBA program to open a series of files,fix them, and save and
close them. I'd like to do this without having to sit in front of the
computer, but before it saves the file it opens up a window telling me that
there will be a "minor loss of fidelity" if it's saved. The original files
were written in Excel 2003 and I'm now using Excel 2007, and the colors are
the problem. But I don't care; I want to run the program and just save them
as is. Is there any way I can turn off the "minor loss of fidelity" warning?

I believe that
Application.DisplayAlerts = False
just before your Save action should keep that from showing up. After the
save re-enable them with
Application.DisplayAlerts = True


"MikeM" wrote:

I've written a VBA program to open a series of files,fix them, and save and
close them. I'd like to do this without having to sit in front of the
computer, but before it saves the file it opens up a window telling me that
there will be a "minor loss of fidelity" if it's saved. The original files
were written in Excel 2003 and I'm now using Excel 2007, and the colors are
the problem. But I don't care; I want to run the program and just save them
as is. Is there any way I can turn off the "minor loss of fidelity" warning?

Thnaks!! That did it.

Mike

"JLatham" wrote:

I believe that
Application.DisplayAlerts = False
just before your Save action should keep that from showing up. After the
save re-enable them with
Application.DisplayAlerts = True


"MikeM" wrote:

I've written a VBA program to open a series of files,fix them, and save and
close them. I'd like to do this without having to sit in front of the
computer, but before it saves the file it opens up a window telling me that
there will be a "minor loss of fidelity" if it's saved. The original files
were written in Excel 2003 and I'm now using Excel 2007, and the colors are
the problem. But I don't care; I want to run the program and just save them
as is. Is there any way I can turn off the "minor loss of fidelity" warning?