View Single Post
  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

Append a /e to the end of your shortcut to open Excel with no splash or Book1.

OR better yet.......

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\OFFICE\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 Thu, 3 Feb 2005 22:28:41 -0000, "Nick Hodge"
wrote:

AFAIK there is no UI setting for this. You could set a Workbook_Open event
in your personal.xls to close the activeworkbook. Just tested it and it
seems to work

Private Sub Workbook_Open()
ActiveWorkbook.Close SaveChanges:=False
End Sub