I want excel to open without Book 1. Following the thread below solves only
part the problem.



This works for opening only excel, but does not appear to work when one
double clicks on an existing excel file to open. I still get the Book 1 when
this is done. The /automation modifier does not seem to help either.

Our IT people put in a shortcut in the C:\Program Files\Microsoft
Office\OFFICE11 directory with the /e /automation switch. The Control
Panel/Folder Options/File Types was modified to open excel using this
shortcut. Now, unless Excel is already open, a double click of an existing
file gives a series of files not found errors. It seems to stumble over the
spaces in the file structure such as between the word DOCUMENTS and the word
AND when looking for a file in C:\Documents and Settings\Excel........ It
says it cannot find the file Documents.xls.

The /e used to work in older versions either with excel only or by double
clicking on a exisitng file. Either way, no Book 1 ever appeared. I am
after this same functionality.


ksn


"Dave Peterson" wrote:

Modify the shortcut (or create an new shortcut) that points at excel.exe, but
add " /e" (w/o the quotes) to the end of the target.

For me (xl2003), my target would look like:

"C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /e



Jwhite wrote:

How do I set Excel to not load/create a "New" Book1, Book2, etc... whenever I
open Excel?

--

Dave Peterson


--
ksn