File Type Ordering Inconsistency

[Julian]

Almost trivial but annoying! [Vista HP, Office 2002]

I have a folder containing Excel .XLS files and CSV files associated with
Excel...

Unfortunately, when I "Group by Type" CSV files appear under "Microsoft
Excel Comma Separated Values Files", whereas XLS files are under "XLS
Files". (Excel Templates are also "Microsoft Excel Template in Windows
Explorer, charts are "Microsoft Excel Chart", etc. etc. i.e. XLS seems to be
an exception)

I'd rather like all the Excel types to be adjacent...

Looked in the registry (The reg key is at HKEY_CLASSES_ROOT\Excel.CSV) and
under the Excel.CSV key is the "(default)" string "Microsoft Excel Comma
Separated Values Files", but surprisingly there is no Excel.XLS key that I
could find to modify to give Windows Explorer a common Type-string
beginning...

How might I assert some control over this? What and where could I change in
the registry? Of course there is the vanilla .xls key, which has as
(default) "Excel.Sheet.8" - if I put a new (default) under Excel.Sheet.8
with the string "Microsoft Excel XLS Files" would that work?

TIA

Julian

 

[Gary Mount]

Add this key
HKEY_CLASSES_ROOT\.xls\PersistentHandler
and add a REG_SZ with the same value as you find in the
Microsoft Excel Chart key.
In my case with Office 2000 the value is
{98de59a0-d175-11cd-a7bd-00006b827d94}
but yours will be different.

I exported my entire key to a text file as an example, as follows.

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\.xls]
"Content Type"="application/vnd.ms-excel"
@="Excel.Sheet.8"

[HKEY_CLASSES_ROOT\.xls\Excel.Sheet.8]
@=""

[HKEY_CLASSES_ROOT\.xls\Excel.Sheet.8\ShellNew]
"FileName"="excel9.xls"

[HKEY_CLASSES_ROOT\.xls\PersistentHandler]
@="{98de59a0-d175-11cd-a7bd-00006b827d94}"

But as I said, this is Office 2000.

 

[Julian]

Thanks for replying Gary -

However, I was under the impression that the PersistentHandler supported the
search/indexing of a file type... I've already got a PersistentHandler under
x.ls (CLSID {98DE59A0-D175-11CD-A7BD-00006B827D94} - just the same as yours
as it happens!)

As it is, the answer would seem to apply to a different question

--
Julian I-Do-Stuff

Some Vista stuff, but mostly just Stuff at http://berossus,blogspot.com

Add this key
HKEY_CLASSES_ROOT\.xls\PersistentHandler
and add a REG_SZ with the same value as you find in the
Microsoft Excel Chart key.
In my case with Office 2000 the value is
{98de59a0-d175-11cd-a7bd-00006b827d94}
but yours will be different.

I exported my entire key to a text file as an example, as follows.

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\.xls]
"Content Type"="application/vnd.ms-excel"
@="Excel.Sheet.8"

[HKEY_CLASSES_ROOT\.xls\Excel.Sheet.8]
@=""

[HKEY_CLASSES_ROOT\.xls\Excel.Sheet.8\ShellNew]
"FileName"="excel9.xls"

[HKEY_CLASSES_ROOT\.xls\PersistentHandler]
@="{98de59a0-d175-11cd-a7bd-00006b827d94}"

But as I said, this is Office 2000.

Almost trivial but annoying! [Vista HP, Office 2002]

I have a folder containing Excel .XLS files and CSV files associated with
Excel...

Unfortunately, when I "Group by Type" CSV files appear under "Microsoft
Excel Comma Separated Values Files", whereas XLS files are under "XLS
Files". (Excel Templates are also "Microsoft Excel Template in Windows
Explorer, charts are "Microsoft Excel Chart", etc. etc. i.e. XLS seems to
be an exception)

I'd rather like all the Excel types to be adjacent...

Looked in the registry (The reg key is at HKEY_CLASSES_ROOT\Excel.CSV)
and under the Excel.CSV key is the "(default)" string "Microsoft Excel
Comma Separated Values Files", but surprisingly there is no Excel.XLS key
that I could find to modify to give Windows Explorer a common Type-string
beginning...

How might I assert some control over this? What and where could I change
in the registry? Of course there is the vanilla .xls key, which has as
(default) "Excel.Sheet.8" - if I put a new (default) under Excel.Sheet.8
with the string "Microsoft Excel XLS Files" would that work?

TIA

Julian

 

[Julian]

That was marked for Send Later!

Nevermind, I was going to add that having just amended the (default) value
immediately under Excel.Sheet.8 to "Microsoft Excel Worksheet" it had no
effect... (after logoff/logon and restart)

What am I missing?

--
Julian I-Do-Stuff

Some Vista stuff, but mostly just Stuff at http://berossus,blogspot.com

Thanks for replying Gary -

However, I was under the impression that the PersistentHandler supported
the search/indexing of a file type... I've already got a PersistentHandler
under x.ls (CLSID {98DE59A0-D175-11CD-A7BD-00006B827D94} - just the same
as yours as it happens!)

As it is, the answer would seem to apply to a different question

--
Julian I-Do-Stuff

Some Vista stuff, but mostly just Stuff at http://berossus,blogspot.com

Add this key
HKEY_CLASSES_ROOT\.xls\PersistentHandler
and add a REG_SZ with the same value as you find in the
Microsoft Excel Chart key.
In my case with Office 2000 the value is
{98de59a0-d175-11cd-a7bd-00006b827d94}
but yours will be different.

I exported my entire key to a text file as an example, as follows.

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\.xls]
"Content Type"="application/vnd.ms-excel"
@="Excel.Sheet.8"

[HKEY_CLASSES_ROOT\.xls\Excel.Sheet.8]
@=""

[HKEY_CLASSES_ROOT\.xls\Excel.Sheet.8\ShellNew]
"FileName"="excel9.xls"

[HKEY_CLASSES_ROOT\.xls\PersistentHandler]
@="{98de59a0-d175-11cd-a7bd-00006b827d94}"

But as I said, this is Office 2000.

Almost trivial but annoying! [Vista HP, Office 2002]

I have a folder containing Excel .XLS files and CSV files associated
with Excel...

Unfortunately, when I "Group by Type" CSV files appear under "Microsoft
Excel Comma Separated Values Files", whereas XLS files are under "XLS
Files". (Excel Templates are also "Microsoft Excel Template in Windows
Explorer, charts are "Microsoft Excel Chart", etc. etc. i.e. XLS seems
to be an exception)

I'd rather like all the Excel types to be adjacent...

Looked in the registry (The reg key is at HKEY_CLASSES_ROOT\Excel.CSV)
and under the Excel.CSV key is the "(default)" string "Microsoft Excel
Comma Separated Values Files", but surprisingly there is no Excel.XLS
key that I could find to modify to give Windows Explorer a common
Type-string beginning...

How might I assert some control over this? What and where could I change
in the registry? Of course there is the vanilla .xls key, which has as
(default) "Excel.Sheet.8" - if I put a new (default) under Excel.Sheet.8
with the string "Microsoft Excel XLS Files" would that work?

TIA

Julian

 

[Julian]

Well, I fixed it - but not through the registry... I just re-associated .xls
with Excel, even though it was already apparently associated! (Clicked
"browse" in the "open with" dialog, kept the "always use this..." check box
checked, navigated to C:\Program Files\Microsoft Office\Office10 and
selected Excel.exe

....must look to see what changed in the registry later... would be rather
informative!

--
Julian I-Do-Stuff

Some Vista stuff, but mostly just Stuff at http://berossus,blogspot.com

That was marked for Send Later!

Nevermind, I was going to add that having just amended the (default) value
immediately under Excel.Sheet.8 to "Microsoft Excel Worksheet" it had no
effect... (after logoff/logon and restart)

What am I missing?

--
Julian I-Do-Stuff

Some Vista stuff, but mostly just Stuff at http://berossus,blogspot.com

Thanks for replying Gary -

However, I was under the impression that the PersistentHandler supported
the search/indexing of a file type... I've already got a
PersistentHandler under x.ls (CLSID
{98DE59A0-D175-11CD-A7BD-00006B827D94} - just the same as yours as it
happens!)

As it is, the answer would seem to apply to a different question

--
Julian I-Do-Stuff

Some Vista stuff, but mostly just Stuff at http://berossus,blogspot.com

Add this key
HKEY_CLASSES_ROOT\.xls\PersistentHandler
and add a REG_SZ with the same value as you find in the
Microsoft Excel Chart key.
In my case with Office 2000 the value is
{98de59a0-d175-11cd-a7bd-00006b827d94}
but yours will be different.

I exported my entire key to a text file as an example, as follows.

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\.xls]
"Content Type"="application/vnd.ms-excel"
@="Excel.Sheet.8"

[HKEY_CLASSES_ROOT\.xls\Excel.Sheet.8]
@=""

[HKEY_CLASSES_ROOT\.xls\Excel.Sheet.8\ShellNew]
"FileName"="excel9.xls"

[HKEY_CLASSES_ROOT\.xls\PersistentHandler]
@="{98de59a0-d175-11cd-a7bd-00006b827d94}"

But as I said, this is Office 2000.



Almost trivial but annoying! [Vista HP, Office 2002]

I have a folder containing Excel .XLS files and CSV files associated
with Excel...

Unfortunately, when I "Group by Type" CSV files appear under "Microsoft
Excel Comma Separated Values Files", whereas XLS files are under "XLS
Files". (Excel Templates are also "Microsoft Excel Template in Windows
Explorer, charts are "Microsoft Excel Chart", etc. etc. i.e. XLS seems
to be an exception)

I'd rather like all the Excel types to be adjacent...

Looked in the registry (The reg key is at HKEY_CLASSES_ROOT\Excel.CSV)
and under the Excel.CSV key is the "(default)" string "Microsoft Excel
Comma Separated Values Files", but surprisingly there is no Excel.XLS
key that I could find to modify to give Windows Explorer a common
Type-string beginning...

How might I assert some control over this? What and where could I
change in the registry? Of course there is the vanilla .xls key, which
has as (default) "Excel.Sheet.8" - if I put a new (default) under
Excel.Sheet.8 with the string "Microsoft Excel XLS Files" would that
work?

TIA

Julian