.XLS file type association problem with two Excel versions

iliace

Well-known Member

Joined

Jan 15, 2008

Messages

3,548

Office Version

1. 365
2. 2016
3. 2010

Platform

1. Windows

• Apr 9, 2008

• #11

 

Upvote 0

Gates Is Antichrist

Well-known Member

Joined

Aug 15, 2002

Messages

1,961

• Apr 9, 2008

• #12

I guess that I asked the wrong question. But since you answered, I see you can set the shortcut key to the one you want, at least.

This is what I have under XP folder options. The icon is the giveaway that it's still 2003. See if you can browse that one (see my original post for location).

 

Upvote 0

iliace

Well-known Member

Joined

Jan 15, 2008

Messages

3,548

Office Version

1. 365
2. 2016
3. 2010

Platform

1. Windows

• Apr 9, 2008

• #13

I actually have both:

Also both available in Open With. I can set the default to be 2003. However, when I open a 2007 database (accdb), I get this:

Next, if I try to double-click a 2003 type file (mdb), I get this:

This is time-consuming, as I'm sure you understand. I don't see why it's necessary.

 

Upvote 0

Gates Is Antichrist

Well-known Member

Joined

Aug 15, 2002

Messages

1,961

• Apr 11, 2008

• #14

Okay, maybe the difference is that I strictly deal with .MDB. I haven't had the misfortune of 2007-specific extensions being blessed upon me. I'm sorry. It does look painful.

At least for those who just open .MDB, this worked for me, so they can try it: after [dual] 2007 installation doubling clicking a .MDB came up on Access 2007. I closed it. I manually opened Access 2003 (such as I have to do with Excel, since that bug isn't solved). Then I double clicked the file again. Presto. He never tries to open Access 2007 again.

 

Upvote 0

ZVI

MrExcel MVP

Joined

Apr 9, 2008

Messages

3,875

Office Version

1. 2019
2. 2016
3. 2010

Platform

1. Windows

• Apr 11, 2008

• #15

Hi Gentlemen!

This puzzle has been solved by me with usage of the followind command line, putting on Start-Run:

"C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /o

Surely, the same key can be applied to Word & Access.

Enjoy this trick!
Vladimir

 

Upvote 0

Gates Is Antichrist

Well-known Member

Joined

Aug 15, 2002

Messages

1,961

• Apr 11, 2008

• #16

Excellent! That takes care of Excel! Fine work!

 

Upvote 0

B

bmurphy

New Member

Joined

Aug 20, 2008

Messages

13

• Aug 20, 2008

• #17

In the folder where EXCEL.EXE is located for office 2003, make a copy of this file and name it EXCEL2003.EXE. Then in the File Types dialog change the XLS extension to run this file.

It worked for me. I did the same for the XLA extension.

Another way that will probably work is to rerun SETUP for office 2003 and do a Repair or similar.

 

Upvote 0

ZVI

MrExcel MVP

Joined

Apr 9, 2008

Messages

3,875

Office Version

1. 2019
2. 2016
3. 2010

Platform

1. Windows

• Aug 20, 2008

• #18

bmurphy said:

In the folder where EXCEL.EXE is located for office 2003, make a copy of this file and name it EXCEL2003.EXE. Then in the File Types dialog change the XLS extension to run this file.

It worked for me. I did the same for the XLA extension.

Another way that will probably work is to rerun SETUP for office 2003 and do a Repair or similar.

Click to expand...

Hi Bmurphy,

Welcome to the board and thanks for adding your tip!
It has induced me to extend my April advice:
The command line from Start-Run would be also:

"C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /regserver

According to description "the key /regserver forces Excel to register itself and then quit. Use this switch when you want Excel to rewrite all its registry keys and reassociate itself with Excel files, such as workbooks, charts, and so on".

The same key can be used for reassociating of WinWord and MSAccess applications.

Regards,
Vladimir

 

Upvote 0