Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Pedr Llwyd
 
Posts: n/a
Default Problem Opening Files

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)
  #2   Report Post  
Jan Karel Pieterse
 
Posts: n/a
Default

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

  #3   Report Post  
Ragdyer
 
Posts: n/a
Default

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 !
---------------------------------------------------------------------------
"Jan Karel Pieterse" wrote in message
...
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening DBF files with Excel 2003 via Windows Explorer ? David Purdy Setting up and Configuration of Excel 2 May 3rd 06 09:21 PM
Running Virus Scan Slowing down opening files Angelina Excel Discussion (Misc queries) 2 August 15th 05 12:41 AM
Problem with opening an Excel - File Roland S. Excel Worksheet Functions 0 June 9th 05 10:37 AM
Opening different files in excell CC Excel Worksheet Functions 1 May 5th 05 10:33 AM
Problem opening an XML file in Excel - getting "ns1:macrosPresent" rprondeau Excel Discussion (Misc queries) 0 December 15th 04 03:39 PM


All times are GMT +1. The time now is 12:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"