"Minor loss of fidelity"
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? |
"Minor loss of fidelity"
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? |
"Minor loss of fidelity"
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? |
All times are GMT +1. The time now is 04:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com