Hello, all,
I use a software called nVision, which automatically runs
queries against a database and produces multiple report
spreadsheets, depending on the selection (such as
department ID, account, etc.). The problem is, several of
the resulting reports may be blank because there is no
activity to report.

Is there a way to suppress the "no-data" reports. I can
create a cell that will show zero dollars, but I don't
know how to stop the automatic save without stopping the
next report from running. What I need is a way to stop
the save of the current file, and then do a close of the
current file, without closing Excel.

Thanks.