Append a /e to your Excel startup command to prevent Book1 from opening.

Go to StartSettingsControl PanelFolder OptionsFile Types

If using WinXP OS you would scroll down to .XLS then "Advanced"OpenEdit.

In Command line the path should be similar to this....

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICExx\EXCEL.EXE" /e

You must have the double quotes and the <space/e prevents a new blank book
from opening.

Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)


Gord Dibben MS Excel MVP

On Mon, 25 Aug 2008 17:47:00 -0700, DaveW
wrote:

Unfortunately, Pete_UK has chosen merely to question my inquiry rather than
supply any information that might assist me in solving the problem.

I have a very good reason for launching the Excel application and then
opening a preexisting workbook. I will not take the time to elaborate on
that issue inasmuch as it might only serve to further complicate this matter.
In any event, as previously stated, when I launch the Excel application, a
"New" workbook titled "Book1" is automatically generated. When I then open a
preexisting workbook, the "New" workbook "Book1" also remains. When I am
finished with the preexisting workbook, I save it, if I have made any changes
to it, and then close it, or I simply close it without having made any
changes. At that point, the newly created workbook titled "Book1" remains
open. When I then attempt to exit Excel, a dialog box appears asking me if I
want to save changes to "Book1." It is this dialog box that has only
recently begun to appear and that I wish to eliminate.


"Pete_UK" wrote:

Why do you launch Excel and automatically generate a new workbook?
(whether used or not?) Or, why do you open a "New" workbook? When you
come to close Excel it doesn't know if you want to save the new file
or not, so it asks you. If you want to avoid the question, as you have
discovered, then don't open a new workbook if you don't need it.

Pete

On Aug 25, 4:32 pm, DaveW wrote:
This relates to Excel 2007 and seems to have started maybe about a week or so
ago. I never had this problem before. It is a nuisance and frustrating to
have to click on "No" in the dialog box when I simply want to exit Excel. It
now happens whenever I have first launched Excel 2007 (a process that
automatically generates a blank, new workbook titled "Book1") and then have
opened a preexisting workbook, or when I have started Excel by clicking on a
preexisting workbook, then opened a "New" workbook (which is titled "Book1"),
saved and closed any and all workbooks other than the new "Book1" (which I
have not used at all), and then try to exit Excel. It may be noteworthy that
this does not happen if I simply start Excel by clicking on a preexisting
workbook and then exit Excel without having made any changes to that
workbook. It seems to occur only when "Book1" (or, I suppose, a "Book2,"
etc.) is involved.