#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 107
Default filename spaces???

Excel 2003 on Win XP all updates.
Something has changed!
With Excel NOT running, if I doubleclick an Excel filename containing spaces
to open it, I get an error message saying Excel can't find the file.
This used not to be the case.
If I remove the spaces and do the same, the file opens with no problem
If I open Excel first then double click, the file opens with no problem.
What needs resetting??
--
donwb
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default filename spaces???

Sometimes one of these works when you're having trouble with double clicking on
the file in windows explorer:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

Maybe one of these will work for you.

donbowyer wrote:

Excel 2003 on Win XP all updates.
Something has changed!
With Excel NOT running, if I doubleclick an Excel filename containing spaces
to open it, I get an error message saying Excel can't find the file.
This used not to be the case.
If I remove the spaces and do the same, the file opens with no problem
If I open Excel first then double click, the file opens with no problem.
What needs resetting??
--
donwb


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default It worked!

Great work! Looked at quite a few sites that listed going into folder options selecting the excel worksheet and editing the open command. That does not work. This worked perfectly.

Thanks much.

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

Maybe one of these will work for you.
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,365
Default filename spaces???

Tools | Options [General] tab
See if the box next to "Ignore other applications" is checked. If it is,
clear the box and try again.



"donbowyer" wrote:

Excel 2003 on Win XP all updates.
Something has changed!
With Excel NOT running, if I doubleclick an Excel filename containing spaces
to open it, I get an error message saying Excel can't find the file.
This used not to be the case.
If I remove the spaces and do the same, the file opens with no problem
If I open Excel first then double click, the file opens with no problem.
What needs resetting??
--
donwb

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 107
Default filename spaces???

Thank you for the 2 replies.
Have done all suggestions but nothong has changed
--
donwb


"JLatham" wrote:

Tools | Options [General] tab
See if the box next to "Ignore other applications" is checked. If it is,
clear the box and try again.



"donbowyer" wrote:

Excel 2003 on Win XP all updates.
Something has changed!
With Excel NOT running, if I doubleclick an Excel filename containing spaces
to open it, I get an error message saying Excel can't find the file.
This used not to be the case.
If I remove the spaces and do the same, the file opens with no problem
If I open Excel first then double click, the file opens with no problem.
What needs resetting??
--
donwb



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default filename spaces???

When you ran the regserver command did Windows Installer come up and do its
thing?

Or did you get an error message?

Maybe have a look at these instructions...................

Go to StartSettingsControl PanelFolder OptionsFile Types

If using WinXP OS you would scroll down to .XLS then "Advanced"OpenEdit.

In Command line the path should be similar to this....

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE" /e

You must have the double quotes and the <space/e prevents a new book from
opening.

Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)


Gord

On Mon, 22 Oct 2007 14:26:00 -0700, donbowyer
wrote:

Thank you for the 2 replies.
Have done all suggestions but nothong has changed


  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 107
Default filename spaces???

In StartSettingsControl PanelFolder OptionsFile TypesAdvancedOpenEdit.
I have:-

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE" /e %1

When I ran the unregserver, followed by the regserver command, the Windows
Installer came up and did its thing OK.

In StartSettingsControl PanelFolder OptionsFile TypesAdvancedOpenEdit.
I now have:-

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE" /e

ie without the <space%1
Under these conditions, doubleclicking an *.xls file name, even without
spaces, does NOT open the file - only Excel, whereas before it did.
If I add <space%1 after the /e, unspaced filenames now open but still not
ones with spaces.

--
donwb


"Gord Dibben" wrote:

When you ran the regserver command did Windows Installer come up and do its
thing?

Or did you get an error message?

Maybe have a look at these instructions...................

Go to StartSettingsControl PanelFolder OptionsFile Types

If using WinXP OS you would scroll down to .XLS then "Advanced"OpenEdit.

In Command line the path should be similar to this....

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE" /e

You must have the double quotes and the <space/e prevents a new book from
opening.

Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)


Gord

On Mon, 22 Oct 2007 14:26:00 -0700, donbowyer
wrote:

Thank you for the 2 replies.
Have done all suggestions but nothong has changed



  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default filename spaces???

How about the rest of the dialog at

StartSettingsControl PanelFolder OptionsFile TypesAdvancedOpenEdit.

Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)


Looks like that?


Gord



On Tue, 23 Oct 2007 01:50:02 -0700, donbowyer
wrote:

In StartSettingsControl PanelFolder OptionsFile TypesAdvancedOpenEdit.
I have:-

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE" /e %1

When I ran the unregserver, followed by the regserver command, the Windows
Installer came up and did its thing OK.

In StartSettingsControl PanelFolder OptionsFile TypesAdvancedOpenEdit.
I now have:-

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE" /e

ie without the <space%1
Under these conditions, doubleclicking an *.xls file name, even without
spaces, does NOT open the file - only Excel, whereas before it did.
If I add <space%1 after the /e, unspaced filenames now open but still not
ones with spaces.


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
Cell("filename") doesn't update to new filename when do save as. Louis Excel Worksheet Functions 2 March 22nd 07 07:27 PM
how do I remove leading spaces and leave the remianing spaces w Debi Excel Worksheet Functions 6 February 28th 07 03:29 PM
+ in filename mkrefting Excel Discussion (Misc queries) 0 October 24th 06 07:44 PM
spaces not recognized as spaces windsurferLA Excel Worksheet Functions 9 July 27th 06 11:49 AM
set filename to <filename-date on open bob engler Excel Worksheet Functions 2 July 13th 06 05:11 AM


All times are GMT +1. The time now is 08:20 PM.

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

About Us

"It's about Microsoft Excel"