Problem Opening Files

[Guest]

When an attempt to open an Exel file by double clicking on the file icon in
Windows Explorer the Exel window opens (without any workbook present) and the
following error message is displayed:

"Cannot find the file 'C:\***.XLS (or one of its components) Make sure the
path (... etc)"

The file can be opened by using the open command within Exel.



This problem first appeared while running MS Office under Windows 98 but has
persisted since upgrading to Windows 2000 Professional. I have tried Windows
update and repairing the program automatically from 'ADD / REMOVE PROGRAMS'

Running

MS Office XP Professional Version 10.0.6626.0

Exel 2002 version 10.0.6501.0

Windows 2000 Professional Version 5.0 (Build 2194 Service Pack 4)

 

[Jan Karel Pieterse]

Hi Pedr,

When an attempt to open an Exel file by double clicking on the file icon in
Windows Explorer the Exel window opens (without any workbook present) and the
following error message is displayed:

"Cannot find the file 'C:\***.XLS (or one of its components) Make sure the
path (... etc)"

How to reinstate Excel's ability to open files with spaces
in their name/path by double clicking:

1. Have Excel correct it

1. Choose start (Start button), Run, type:
"C:\Program Files\Microsoft Office\Office\EXCEL.EXE" /Regserver
2. Click OK

2. Do it yourself

1. Open Windows Explorer.
2. Choose from its menu: View, Options. (or View / Folder Options in Windows 98)
3. Select the File Types tab
4. Scroll to Microsoft Excel Worksheet
5. Click Edit
6. Select the OPEN entry (it should be highlighted (bolded)
7. Click Edit and check that the fields are set as follows:
a) Application used: should be EXCEL.EXE, loaded from the correct directory
b) Use DDE should be checked
c) The DDE message should be (exactly): [Open("%1")]
d) Application should be: excel
e) DDE Application not running should be empty
f) Topic should be: system
8. Click OK
9. Click Close
10. If you wish to double-click other Excel file types, e.g. template
(xlt) or workspace (xlw), select the appropriate type in the File Types
tab and repeat from step (5)

For the XLVIEWER:

- Use DDE turned OFF
- Command line: "c:\program files\xlview\xlview.exe" "%1"

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[Ragdyer]

May I suggest that before getting into all those procedures, you first check
this:

<Tools> <Options> <General> tab,
And make sure that
"Ignore Other Applications"
Is *UNCHECKED*
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

Hi Pedr,

When an attempt to open an Exel file by double clicking on the file icon in
Windows Explorer the Exel window opens (without any workbook present) and the
following error message is displayed:

"Cannot find the file 'C:\***.XLS (or one of its components) Make sure the
path (... etc)"

How to reinstate Excel's ability to open files with spaces
in their name/path by double clicking:

1. Have Excel correct it

1. Choose start (Start button), Run, type:
"C:\Program Files\Microsoft Office\Office\EXCEL.EXE" /Regserver
2. Click OK

2. Do it yourself

1. Open Windows Explorer.
2. Choose from its menu: View, Options. (or View / Folder Options in Windows 98)
3. Select the File Types tab
4. Scroll to Microsoft Excel Worksheet
5. Click Edit
6. Select the OPEN entry (it should be highlighted (bolded)
7. Click Edit and check that the fields are set as follows:
a) Application used: should be EXCEL.EXE, loaded from the correct directory
b) Use DDE should be checked
c) The DDE message should be (exactly): [Open("%1")]
d) Application should be: excel
e) DDE Application not running should be empty
f) Topic should be: system
8. Click OK
9. Click Close
10. If you wish to double-click other Excel file types, e.g. template
(xlt) or workspace (xlw), select the appropriate type in the File Types
tab and repeat from step (5)

For the XLVIEWER:

- Use DDE turned OFF
- Command line: "c:\program files\xlview\xlview.exe" "%1"

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com