Double Click Problem

K

Ken Hutson

Hi Group,

Excel XP and Windows 2000. If I double click on an Excel workbook file in
Windows Explorer, Excel starts, opens the workbook. Then an OK only dialog
box appears and gives this message;

"Cannot find the file <myclicked filename>.xls (or one of it's components).
Mkae sure the path and filename are correct and that all required libraries
are available."

I click OK and everything looks normal in Excel. On the other hand, if I
start Excel and then File->Open through the Excel menu, there is no problem
at all.

Anyone care to comment?

Thanks,
Ken Hutson
San Antonio, TX
 
G

Gord Dibben

Ken

Your Excel file association may be lost.

Start>Run "excel.exe /regserver"(no quotes and note the space before the /
mark).

You may have to enter your full path to excel.exe....in that case surround
with quotes as in..... "C:\mypath\to Excel\somewhere\excel.exe" /regserver

If this doesn't do the trick.............

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
 
K

Ken Hutson

Thanks Gord,

I will investigate your solutions.

Ken Hutson
San Antonio, TX

Gord Dibben said:
Ken

Your Excel file association may be lost.

Start>Run "excel.exe /regserver"(no quotes and note the space before the /
mark).

You may have to enter your full path to excel.exe....in that case surround
with quotes as in..... "C:\mypath\to Excel\somewhere\excel.exe" /regserver

If this doesn't do the trick.............

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

Hi Group,

Excel XP and Windows 2000. If I double click on an Excel workbook file in
Windows Explorer, Excel starts, opens the workbook. Then an OK only dialog
box appears and gives this message;

"Cannot find the file <myclicked filename>.xls (or one of it's components).
Mkae sure the path and filename are correct and that all required libraries
are available."

I click OK and everything looks normal in Excel. On the other hand, if I
start Excel and then File->Open through the Excel menu, there is no problem
at all.

Anyone care to comment?

Thanks,
Ken Hutson
San Antonio, TX
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top