/e switch isn't working

T

Tim

I'm using Excel 2002 SP-3 on Windows 2000 Professional.

When I double-click an Excel file, it opens that file but
also opens a blank book1 file.

I've set the 'Application used to open this file' in
Windows to:
"C:\Program Files\Microsoft Office\Office10
\EXCEL.EXE" /e "%1"

The /e switch is supposed to open the Excel file without
the blank book1.

Is there anyway to stop that book1 from opening?
 
G

Gord Dibben

Tim

I would get rid of the "%1"

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
 
G

Guest

Thanks for your response. The %1 automatically gets added
to the line every time I click OK. I have to go back in
and add the "" around it. Otherwise, it prevents files
with spaces from opening.

In any case, I found what was actually causing the
problem. There was a software package that we had
installed on the PC's in question called 'QI Macros for
Excel'. This was an add-in to Excel which assisted in Six
Sigma reporting and analysis. As soon as I removed that
product, the issue went away.
-----Original Message-----
Tim

I would get rid of the "%1"

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
Click to expand...
(delete the said:
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

I'm using Excel 2002 SP-3 on Windows 2000 Professional.

When I double-click an Excel file, it opens that file but
also opens a blank book1 file.

I've set the 'Application used to open this file' in
Windows to:
"C:\Program Files\Microsoft Office\Office10
\EXCEL.EXE" /e "%1"

The /e switch is supposed to open the Excel file without
the blank book1.

Is there anyway to stop that book1 from opening?
Click to expand...

.
Click to expand...
 
Top