Strange Errors When Opening Spreadsheet

[paul.nash]

Okay here's a weird one....but perhaps i'm being stupid....

when a user goes to open up an excel file (eg, called testing 123.xls)

it comes up with the following.....

'c:\temp\testing.xls' could not be found. check the spelling of th
filename, and verify that the file location is correct.

when you click ok it will then come up with the next message being ...

'123.xls' could not be found. check the spelling of the filename, an
verify that the file location is correct.

when you click ok the file opens fine.

however if the file was called testing123.xls it would open straight u
without any errors.

does anyone have an idea why this is happening.

Any help would be appreciated.

cheers :

 

[David]

Paul

You don't say how your user is launching this.

Certainly if you use Start | Run and type in the Open box the text:

Excel testing 123.xls

then Excel would start, and would see two arguments: testing (which would
make it look for testing.xls) and 123.xls, and attempt to open both these
spreadsheets.

Is this the case? If so put quotes round the name that has a space in, for
example:
Excel "testing 123.xls"
and you should then be OK.

David

 

[paul.nash]

this is being opened in 2 ways...

either via an email attachment that something has sent or by saving th
attachment to c drive and then going to windows explorer and doubl
clicking on the file.

The same happens if you open excel and then go file open and search fo
the file that way

 

[paul.nash]

can anyone else help with this

 

[Gord Dibben]

Paul

First try the standard fix(es)......Tools>Options>General uncheck "ignore
other applications"

OR 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 neither of the above does 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 XL2002