Hi,

I know this is possible, but forgotten how to do it. I want Excel to
stop opening book1.xls when I open another workbooks.

I know you can use the switch /e in the shortcut, but that only works
when opening Excel using that shortcut.

I want Excel to stop opening book1.xls (the default) when I open any
workbook.

Thanks,

Dan


--
dpcarlton
------------------------------------------------------------------------
dpcarlton's Profile: http://www.excelforum.com/member.php...o&userid=29364
View this thread: http://www.excelforum.com/showthread...hreadid=490755

If you're really opening book1.xls (with the .xls extension), look for that
book1.xls in your XLStart folder (and move it/delete it).

But the only way I know of to stop book1 (without the .xls extension) from
opening is to use the /e option.

dpcarlton wrote:

Hi,

I know this is possible, but forgotten how to do it. I want Excel to
stop opening book1.xls when I open another workbooks.

I know you can use the switch /e in the shortcut, but that only works
when opening Excel using that shortcut.

I want Excel to stop opening book1.xls (the default) when I open any
workbook.

Thanks,

Dan

--
dpcarlton
------------------------------------------------------------------------
dpcarlton's Profile: http://www.excelforum.com/member.php...o&userid=29364
View this thread: http://www.excelforum.com/showthread...hreadid=490755

--

Dave Peterson

Thanks for the reply, but unfortunately it does not help.

It does not exist in the XLSTART folder, I wish it was that easy. It
has always been an issue with Excel, where it opens up a blank workbook
on start, and Book1.xls just happens to be the name is choses.

If I remember correctly, it was a registry setting required to fix
this.


--
dpcarlton
------------------------------------------------------------------------
dpcarlton's Profile: http://www.excelforum.com/member.php...o&userid=29364
View this thread: http://www.excelforum.com/showthread...hreadid=490755

Maybe it's in a different xlstart folder

Windows start button|search
for book1.xls



dpcarlton wrote:

Thanks for the reply, but unfortunately it does not help.

It does not exist in the XLSTART folder, I wish it was that easy. It
has always been an issue with Excel, where it opens up a blank workbook
on start, and Book1.xls just happens to be the name is choses.

If I remember correctly, it was a registry setting required to fix
this.

--
dpcarlton
------------------------------------------------------------------------
dpcarlton's Profile: http://www.excelforum.com/member.php...o&userid=29364
View this thread: http://www.excelforum.com/showthread...hreadid=490755

--

Dave Peterson

Go to StartSettingsFolderOptionsFile Types. Scroll down to MS Excel
Worksheet. Then if running Win98 OS Edit select "Open" and Edit.

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\OFFICE10\EXCEL.EXE" /e (delete the <sp/e
if you want Book1 to open.

You must have the double quotes.

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

Application should read "Excel"(no quotes)


Gord Dibben Excel MVP

On Mon, 5 Dec 2005 10:19:57 -0600, dpcarlton
wrote:


Thanks for the reply, but unfortunately it does not help.

It does not exist in the XLSTART folder, I wish it was that easy. It
has always been an issue with Excel, where it opens up a blank workbook
on start, and Book1.xls just happens to be the name is choses.

If I remember correctly, it was a registry setting required to fix
this.