"Minor loss of fidelity"

G

Guest

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?
 
G

Guest

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
 
G

Guest

Thnaks!! That did it.

Mike

JLatham said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding Cell with Minor loss of fidelity 1
Where is the "minor loss of fidelity"? 7
minor loss fidelity 5
Loss of Fidelity 1
Loss of fidelity question 1
check compatibility 3
loss of fidelity error when saving excel work book 1
Minor Loss of Fidelity 1

Top