| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
File associate setting in Excel
I found a very strange instance.
When I double click a excel file, for example form the path "D:\Profiles\jimmyl\My Documents\05. ABC.xls" Excel with Open the file "D:\Profiles\jimmyl\My" first and result in file not found, and then open "Documents\05." and result in file not found, and then open the file "ABC.xls" and result in file not found. At last it will open the file. How come windows treat the space as a space and separate the opening of a single file? I found that it may be related to the Windows Explorer file associate setting. The following setting is found. Action - &Open Application used to perform action - "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /e %1 Use DDE DDE Message - [open("%1")] Application - EXCEL Topic - System Any ideas to fix this problem? And I try to delete the "%1" after /e but it fail, why? Any can help? Regards, Jim28 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
File associate setting in Excel
I have try both option, but didn't work. Thanks.
"Nick Hodge" wrote: Jim In Excel try ToolsOptionsGeneralIgnore other applications (un-checked) If this fails, go to startrun... in Windows and enter excel.exe \regserver (You may need to enter the full path of Excel exe) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "jim28" wrote in message ... I found a very strange instance. When I double click a excel file, for example form the path "D:\Profiles\jimmyl\My Documents\05. ABC.xls" Excel with Open the file "D:\Profiles\jimmyl\My" first and result in file not found, and then open "Documents\05." and result in file not found, and then open the file "ABC.xls" and result in file not found. At last it will open the file. How come windows treat the space as a space and separate the opening of a single file? I found that it may be related to the Windows Explorer file associate setting. The following setting is found. Action - &Open Application used to perform action - "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /e %1 Use DDE DDE Message - [open("%1")] Application - EXCEL Topic - System Any ideas to fix this problem? And I try to delete the "%1" after /e but it fail, why? Any can help? Regards, Jim28 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
File associate setting in Excel
Some people have posted that when they unregister excel, it gets fixed.
This is my standard answer: 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. jim28 wrote: I have try both option, but didn't work. Thanks. "Nick Hodge" wrote: Jim In Excel try ToolsOptionsGeneralIgnore other applications (un-checked) If this fails, go to startrun... in Windows and enter excel.exe \regserver (You may need to enter the full path of Excel exe) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "jim28" wrote in message ... I found a very strange instance. When I double click a excel file, for example form the path "D:\Profiles\jimmyl\My Documents\05. ABC.xls" Excel with Open the file "D:\Profiles\jimmyl\My" first and result in file not found, and then open "Documents\05." and result in file not found, and then open the file "ABC.xls" and result in file not found. At last it will open the file. How come windows treat the space as a space and separate the opening of a single file? I found that it may be related to the Windows Explorer file associate setting. The following setting is found. Action - &Open Application used to perform action - "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /e %1 Use DDE DDE Message - [open("%1")] Application - EXCEL Topic - System Any ideas to fix this problem? And I try to delete the "%1" after /e but it fail, why? Any can help? Regards, Jim28 -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
File associate setting in Excel
Thanks Dave. It's works.
"Dave Peterson" wrote: Some people have posted that when they unregister excel, it gets fixed. This is my standard answer: 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. jim28 wrote: I have try both option, but didn't work. Thanks. "Nick Hodge" wrote: Jim In Excel try ToolsOptionsGeneralIgnore other applications (un-checked) If this fails, go to startrun... in Windows and enter excel.exe \regserver (You may need to enter the full path of Excel exe) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "jim28" wrote in message ... I found a very strange instance. When I double click a excel file, for example form the path "D:\Profiles\jimmyl\My Documents\05. ABC.xls" Excel with Open the file "D:\Profiles\jimmyl\My" first and result in file not found, and then open "Documents\05." and result in file not found, and then open the file "ABC.xls" and result in file not found. At last it will open the file. How come windows treat the space as a space and separate the opening of a single file? I found that it may be related to the Windows Explorer file associate setting. The following setting is found. Action - &Open Application used to perform action - "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /e %1 Use DDE DDE Message - [open("%1")] Application - EXCEL Topic - System Any ideas to fix this problem? And I try to delete the "%1" after /e but it fail, why? Any can help? Regards, Jim28 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
| Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Hybrid Mode
