ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Working with Both Excel 2003 and 2007 (https://www.excelbanter.com/excel-programming/440300-working-both-excel-2003-2007-a.html)

Quietman

Working with Both Excel 2003 and 2007
 
I'm in the middle of transitioning from 2003 to 2007 (half company on each
version)
How do you set it so that Excel 2007 in the primary excel...ie when openning
a file from it automatically defaults to 2007 insted of 2003

Can this be done?

Thanks
--
Helping Is always a good thing

Mike H

Working with Both Excel 2003 and 2007
 
Hi,

I have E2003, E2007 & E2010 on the same machine and as I've added new
versions the latest version has become the 'default' version.

Are you saying this isn't happening?
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"QuietMan" wrote:

I'm in the middle of transitioning from 2003 to 2007 (half company on each
version)
How do you set it so that Excel 2007 in the primary excel...ie when openning
a file from it automatically defaults to 2007 insted of 2003

Can this be done?

Thanks
--
Helping Is always a good thing


Gord Dibben

Working with Both Excel 2003 and 2007
 
Since 2003 has decided it wants to be the default, de-register 2003 and
re-register 2007

Close Excel first and On the Windows Taskbar

StartRun "C:\yourpathto2003\excel.exe" /unregserver

See the space between exe and /unregserver.

Then register 2007

StartRun "C:\yourpathto2007\excel.exe" /regserver

This process should make Excel 2007 the default for opening files.

You may not have to unregister 2003 first but I err on the side of
caution<g


Gord Dibben MS Excel MVP


On Fri, 5 Mar 2010 12:58:49 -0800, QuietMan
wrote:

I'm in the middle of transitioning from 2003 to 2007 (half company on each
version)
How do you set it so that Excel 2007 in the primary excel...ie when openning
a file from it automatically defaults to 2007 insted of 2003

Can this be done?

Thanks



Quietman

Working with Both Excel 2003 and 2007
 
Yes that's what I'm saying...it just started to default to excel 2003. Even
if it's an excel 2007 file
--
Helping Is always a good thing


"Mike H" wrote:

Hi,

I have E2003, E2007 & E2010 on the same machine and as I've added new
versions the latest version has become the 'default' version.

Are you saying this isn't happening?
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"QuietMan" wrote:

I'm in the middle of transitioning from 2003 to 2007 (half company on each
version)
How do you set it so that Excel 2007 in the primary excel...ie when openning
a file from it automatically defaults to 2007 insted of 2003

Can this be done?

Thanks
--
Helping Is always a good thing


Dave Peterson

Working with Both Excel 2003 and 2007
 
Just to be contrary, I don't usually unregister xl2003 first. I figure that
reregistering xl2007 should be enough to take over the association.

I'm not sure what the heck gets reset when you unregister a version.

But if my suggestion failed, I'd use Gord's!

Gord Dibben wrote:

Since 2003 has decided it wants to be the default, de-register 2003 and
re-register 2007

Close Excel first and On the Windows Taskbar

StartRun "C:\yourpathto2003\excel.exe" /unregserver

See the space between exe and /unregserver.

Then register 2007

StartRun "C:\yourpathto2007\excel.exe" /regserver

This process should make Excel 2007 the default for opening files.

You may not have to unregister 2003 first but I err on the side of
caution<g

Gord Dibben MS Excel MVP

On Fri, 5 Mar 2010 12:58:49 -0800, QuietMan
wrote:

I'm in the middle of transitioning from 2003 to 2007 (half company on each
version)
How do you set it so that Excel 2007 in the primary excel...ie when openning
a file from it automatically defaults to 2007 insted of 2003

Can this be done?

Thanks


--

Dave Peterson

Mike H

Working with Both Excel 2003 and 2007
 
Hi,

You need to unregister 2003 as default

Start|Run and enter

"path to e2003\excel.exe" /unregserver

then start run

"path to e2007\excel.exe" /regserver

Note the syntax is very finnicky, see the space before /

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"QuietMan" wrote:

Yes that's what I'm saying...it just started to default to excel 2003. Even
if it's an excel 2007 file
--
Helping Is always a good thing


"Mike H" wrote:

Hi,

I have E2003, E2007 & E2010 on the same machine and as I've added new
versions the latest version has become the 'default' version.

Are you saying this isn't happening?
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"QuietMan" wrote:

I'm in the middle of transitioning from 2003 to 2007 (half company on each
version)
How do you set it so that Excel 2007 in the primary excel...ie when openning
a file from it automatically defaults to 2007 insted of 2003

Can this be done?

Thanks
--
Helping Is always a good thing



All times are GMT +1. The time now is 10:48 PM.

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