Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 109
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,501
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 109
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,501
Default 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

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22,906
Default 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




  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple VBA Code Working in Excel 2007 but not Excel 2003 #N/A KMH Excel Programming 1 March 3rd 10 09:25 AM
Excel 2003 Match formula not working in Excel 2007 CHKMSTrainer Excel Programming 3 October 24th 08 10:39 PM
Simple Excel 2003 macro not working in Excel 2007 Bryan Excel Programming 0 June 19th 08 02:33 PM
Excel 2007 Macro Help (Excel 2003 not working in 2007) Pman Excel Discussion (Misc queries) 4 May 29th 08 06:29 PM
Pivot in excel 2003 is not working when open in excel 2007 Jakob[_2_] Excel Worksheet Functions 2 April 15th 08 11:47 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"