Error loading excel files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help Experts

OS : WinXP SP
Office : Office 9

Excel alway prompt error locating file when i double click on any excel file on my desktop!

Example if my file located at : c:\document and setting\%userName%\Desktop\Myexcel.xl
when i double-click at this file, Excel program will start up and showing it cannot
find "c:\document.xls.
and after i click OK. another message show it cannot find "and.xls
follow by cannot find "and setting.xls" and so on.. then the excel file i want will show up at the end

but no problem with Words documents

It's very annoying.. Please help !!!
Thanks!!!
 
Hi Alfred,
Excel alway prompt error locating file when i double click on any excel file on my desktop!!
Click to expand...

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
www.jkp-ads.com
 
I am having a similar problem
I can open workbooks from Windows Explorer all day long. However, I have a certain workbook that contains a macro that automatically creates a text data import. The macro only runs if the user chooses. If I open the workbook and do not run the macro, I can open other workbooks from Windows Explorer. However, once the macro has been run, I cannot open workbooks from Explorer, but can open them by using Excel's File...Open command. If I close all instances of Excel normal double-click to open functionalty returns
I have checked that this it is not because of the .XLS file-type being registered incorrectly. Also, Ignore Other Applications in Excel's Options...General tab is not checked

Here is the code for the import. I *know* this is causing the problem because disabling this code and then running the remainder of the code (which works fine but thinks no data exists) doesn't cause the problem I described above

sExtCSVFilespec = "C:\MyData\MyTextFile.csv

'Import the data via a TEXT impor
With ActiveSheet.QueryTables.Add(Connection:="TEXT;" & sExtCSVFilespec, Destination:=Range("A2")
.name = sDataSourceNam
.FieldNames = Tru
.RowNumbers = Fals
.FillAdjacentFormulas = Fals
.PreserveFormatting = Tru
.RefreshOnFileOpen = Fals
.RefreshStyle = xlInsertDeleteCell
.SavePassword = Fals
.SaveData = Tru
.AdjustColumnWidth = Tru
.RefreshPeriod =
.TextFilePromptOnRefresh = Fals
.TextFilePlatform = 43
.TextFileStartRow =
.TextFileParseType = xlDelimite
.TextFileTextQualifier = xlTextQualifierDoubleQuot
.TextFileConsecutiveDelimiter = Fals
.TextFileTabDelimiter = Fals
.TextFileSemicolonDelimiter = Fals
.TextFileCommaDelimiter = Tru
.TextFileSpaceDelimiter = Fals
.TextFileColumnDataTypes = Array(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
.TextFileTrailingMinusNumbers = Tru
.Refresh BackgroundQuery:=Fals
End Wit

Any help will be greatly appreciated.
 
Hi Jan !

The first method which let excel correct the problem really solved my problem ! Thanks alot !!

actually i did try to modify the File type option setting from Folder option previously..
i find the there's some sort of switch at the end of command to excecute.. (...excel.exe" %1)
but i check on other PC, it show (...excel.exe" /e) so i try to change it to same as those PC with no problem,
after i save it.. it automatically append it as (...excel.exe" /e %1) again.

Thanks alot, you are a life saver !!!!
 
Back
Top