open a blank workbook

[R.VENKATARAMAN]

in my brothers computer when he clicks <start-programme-excel> a new
workbook is NOTopned. He has to again click <file(menu)-new> or <new > icon
to get a blank workbook . But in my computer automatically new blank
workbook is opened. Excel help is not much help. I tried to find out in
tools-option-general I could not get any idea. There is file in
<c:\windows\micrososft\excel> in addition to xlstart folder there is a file
with .xlb extension in my computer. Is that a blank excel file. what is
the significance of <xlb> extension as agfainst <xls> extension.

any ideas.

 

[Jim May]

Under the file structure of your Excel.exe installation there should be a
folder named XLStart; Open a new workbook as you have and make all the
changes to it you want so that it "looks and feels" the way you want a
normal new workbook to look. Then do a File Save - navigate to the XLStart
folder and open it -- then in the box under the filename select Files of
type: Template (*.xlt) and type in "Book" as File name, and OK.
Then Close the file and exit out of excel completely.
Henceforth, as you Open Excel, Programs, Excel
Automatically a copy of your Book.xlt will appear as Book1
HTH

 

[Gord Dibben]

Perhaps your brother's shortcut to Excel has a /e appended to the path.

Go to Start>Settings>Folder>Options>File 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">Open>Edit.

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

 

[R.VENKATARAMAN]

thank you both of you

Perhaps your brother's shortcut to Excel has a /e appended to the path.

Go to Start>Settings>Folder>Options>File 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">Open>Edit.

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

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e (delete the

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

in my brothers computer when he clicks <start-programme-excel> a new
workbook is NOTopned. He has to again click <file(menu)-new> or <new > icon
to get a blank workbook . But in my computer automatically new blank
workbook is opened. Excel help is not much help. I tried to find out in
tools-option-general I could not get any idea. There is file in
<c:\windows\micrososft\excel> in addition to xlstart folder there is a file
with .xlb extension in my computer. Is that a blank excel file. what is
the significance of <xlb> extension as agfainst <xls> extension.

any ideas.