ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   File associate setting in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/94868-file-associate-setting-excel.html)

jim28

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



Nick Hodge

File associate setting in Excel
 
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





jim28

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






Dave Peterson

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

jim28

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



All times are GMT +1. The time now is 07:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com