PC Review


Reply
Thread Tools Rating: Thread Rating: 2 votes, 3.00 average.

how to change between Excel 2003 and 2010 as default

 
 
Lynn McGuire
Guest
Posts: n/a
 
      18th Apr 2011
How to change between Excel 2003 and 2010 as default on your pc
(note excel 2003 must be installed in a special directory so
that it does not overwrite excel 2010 files):

excel2003.bat

rem Enter this first to disassociate an excel version...
"c:\program files (x86)\microsoft Office2003\Office11\Excel.exe" /unregserver
"c:\program files (x86)\microsoft Office\Office14\Excel.exe" /unregserver
rem Then enter this to specify the default version...
"c:\program files (x86)\microsoft Office2003\Office11\Excel.exe" /regserver

excel2010.bat

rem Enter this first to disassociate an excel version...
"c:\program files (x86)\microsoft Office2003\Office11\Excel.exe" /unregserver
"c:\program files (x86)\microsoft Office\Office14\Excel.exe" /unregserver
rem Then enter this to specify the default version...
"c:\program files (x86)\microsoft Office\Office14\Excel.exe" /regserver

Sincerely,
Lynn McGuire
 
Reply With Quote
 
 
 
 
GS
Guest
Posts: n/a
 
      18th Apr 2011
Lynn McGuire explained on 4/18/2011 :
> How to change between Excel 2003 and 2010 as default on your pc
> (note excel 2003 must be installed in a special directory so
> that it does not overwrite excel 2010 files):
>
> excel2003.bat
>
> rem Enter this first to disassociate an excel version...
> "c:\program files (x86)\microsoft Office2003\Office11\Excel.exe" /unregserver
> "c:\program files (x86)\microsoft Office\Office14\Excel.exe" /unregserver
> rem Then enter this to specify the default version...
> "c:\program files (x86)\microsoft Office2003\Office11\Excel.exe" /regserver
>
> excel2010.bat
>
> rem Enter this first to disassociate an excel version...
> "c:\program files (x86)\microsoft Office2003\Office11\Excel.exe" /unregserver
> "c:\program files (x86)\microsoft Office\Office14\Excel.exe" /unregserver
> rem Then enter this to specify the default version...
> "c:\program files (x86)\microsoft Office\Office14\Excel.exe" /regserver
>
> Sincerely,
> Lynn McGuire


Normally, the last installed version becomes the default Excel. I have
all versions since v8 installed on the same machine. Whenever a
previous version gets updates OR repairs, it somehow becomes the
default version because I believe it assumes 'last installed' status.

Having these batch files is a big help over having to use CDs every
time I want to change my default version. Thanks for sharing!<g>

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


 
Reply With Quote
 
 
 
 
Lynn McGuire
Guest
Posts: n/a
 
      18th Apr 2011
On 4/18/2011 3:26 PM, GS wrote:
> Lynn McGuire explained on 4/18/2011 :
>> How to change between Excel 2003 and 2010 as default on your pc
>> (note excel 2003 must be installed in a special directory so
>> that it does not overwrite excel 2010 files):
>>
>> excel2003.bat
>>
>> rem Enter this first to disassociate an excel version...
>> "c:\program files (x86)\microsoft Office2003\Office11\Excel.exe" /unregserver
>> "c:\program files (x86)\microsoft Office\Office14\Excel.exe" /unregserver
>> rem Then enter this to specify the default version...
>> "c:\program files (x86)\microsoft Office2003\Office11\Excel.exe" /regserver
>>
>> excel2010.bat
>>
>> rem Enter this first to disassociate an excel version...
>> "c:\program files (x86)\microsoft Office2003\Office11\Excel.exe" /unregserver
>> "c:\program files (x86)\microsoft Office\Office14\Excel.exe" /unregserver
>> rem Then enter this to specify the default version...
>> "c:\program files (x86)\microsoft Office\Office14\Excel.exe" /regserver
>>
>> Sincerely,
>> Lynn McGuire

>
> Normally, the last installed version becomes the default Excel. I have all versions since v8 installed on the same machine. Whenever
> a previous version gets updates OR repairs, it somehow becomes the default version because I believe it assumes 'last installed' status.
>
> Having these batch files is a big help over having to use CDs every time I want to change my default version. Thanks for sharing!<g>


You are welcome.

Lynn



 
Reply With Quote
 
GS
Guest
Posts: n/a
 
      19th Apr 2011
Lynn McGuire has brought this to us :
> How to change between Excel 2003 and 2010 as default on your pc
> (note excel 2003 must be installed in a special directory so
> that it does not overwrite excel 2010 files):
>
> excel2003.bat
>
> rem Enter this first to disassociate an excel version...
> "c:\program files (x86)\microsoft Office2003\Office11\Excel.exe" /unregserver
> "c:\program files (x86)\microsoft Office\Office14\Excel.exe" /unregserver
> rem Then enter this to specify the default version...
> "c:\program files (x86)\microsoft Office2003\Office11\Excel.exe" /regserver
>
> excel2010.bat
>
> rem Enter this first to disassociate an excel version...
> "c:\program files (x86)\microsoft Office2003\Office11\Excel.exe" /unregserver
> "c:\program files (x86)\microsoft Office\Office14\Excel.exe" /unregserver
> rem Then enter this to specify the default version...
> "c:\program files (x86)\microsoft Office\Office14\Excel.exe" /regserver
>
> Sincerely,
> Lynn McGuire


Interestingly, I was able to change from XL2007 to XL2003, but I can't
seem to change back to XL2007. Have you been able to switch back&forth?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


 
Reply With Quote
 
Lynn McGuire
Guest
Posts: n/a
 
      20th Apr 2011
On 4/19/2011 4:36 PM, GS wrote:
> Lynn McGuire has brought this to us :
>> How to change between Excel 2003 and 2010 as default on your pc
>> (note excel 2003 must be installed in a special directory so
>> that it does not overwrite excel 2010 files):
>>
>> excel2003.bat
>>
>> rem Enter this first to disassociate an excel version...
>> "c:\program files (x86)\microsoft Office2003\Office11\Excel.exe" /unregserver
>> "c:\program files (x86)\microsoft Office\Office14\Excel.exe" /unregserver
>> rem Then enter this to specify the default version...
>> "c:\program files (x86)\microsoft Office2003\Office11\Excel.exe" /regserver
>>
>> excel2010.bat
>>
>> rem Enter this first to disassociate an excel version...
>> "c:\program files (x86)\microsoft Office2003\Office11\Excel.exe" /unregserver
>> "c:\program files (x86)\microsoft Office\Office14\Excel.exe" /unregserver
>> rem Then enter this to specify the default version...
>> "c:\program files (x86)\microsoft Office\Office14\Excel.exe" /regserver
>>
>> Sincerely,
>> Lynn McGuire

>
> Interestingly, I was able to change from XL2007 to XL2003, but I can't seem to change back to XL2007. Have you been able to switch
> back&forth?


Yes. Between 203 and 2010. Make sure that your programs paths
in those batch files are absolutely correct.

Lynn

 
Reply With Quote
 
GS
Guest
Posts: n/a
 
      20th Apr 2011
Lynn McGuire brought next idea :
> On 4/19/2011 4:36 PM, GS wrote:
>> Lynn McGuire has brought this to us :
>>> How to change between Excel 2003 and 2010 as default on your pc
>>> (note excel 2003 must be installed in a special directory so
>>> that it does not overwrite excel 2010 files):
>>>
>>> excel2003.bat
>>>
>>> rem Enter this first to disassociate an excel version...
>>> "c:\program files (x86)\microsoft Office2003\Office11\Excel.exe"
>>> /unregserver
>>> "c:\program files (x86)\microsoft Office\Office14\Excel.exe" /unregserver
>>> rem Then enter this to specify the default version...
>>> "c:\program files (x86)\microsoft Office2003\Office11\Excel.exe"
>>> /regserver
>>>
>>> excel2010.bat
>>>
>>> rem Enter this first to disassociate an excel version...
>>> "c:\program files (x86)\microsoft Office2003\Office11\Excel.exe"
>>> /unregserver
>>> "c:\program files (x86)\microsoft Office\Office14\Excel.exe" /unregserver
>>> rem Then enter this to specify the default version...
>>> "c:\program files (x86)\microsoft Office\Office14\Excel.exe" /regserver
>>>
>>> Sincerely,
>>> Lynn McGuire

>>
>> Interestingly, I was able to change from XL2007 to XL2003, but I can't seem
>> to change back to XL2007. Have you been able to switch
>> back&forth?

>
> Yes. Between 203 and 2010. Make sure that your programs paths
> in those batch files are absolutely correct.
>
> Lynn


Strange! The paths are identical except for the version number since
they're all installed under the same main folder...

"C:\Program Files\Microsoft Office\Office11\Office11\Excel.exe"
"C:\Program Files\Microsoft Office\Office12\Office12\Excel.exe"

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


 
Reply With Quote
 
Lynn McGuire
Guest
Posts: n/a
 
      20th Apr 2011
On 4/19/2011 7:44 PM, GS wrote:
> Lynn McGuire brought next idea :
>> On 4/19/2011 4:36 PM, GS wrote:
>>> Lynn McGuire has brought this to us :
>>>> How to change between Excel 2003 and 2010 as default on your pc
>>>> (note excel 2003 must be installed in a special directory so
>>>> that it does not overwrite excel 2010 files):
>>>>
>>>> excel2003.bat
>>>>
>>>> rem Enter this first to disassociate an excel version...
>>>> "c:\program files (x86)\microsoft Office2003\Office11\Excel.exe" /unregserver
>>>> "c:\program files (x86)\microsoft Office\Office14\Excel.exe" /unregserver
>>>> rem Then enter this to specify the default version...
>>>> "c:\program files (x86)\microsoft Office2003\Office11\Excel.exe" /regserver
>>>>
>>>> excel2010.bat
>>>>
>>>> rem Enter this first to disassociate an excel version...
>>>> "c:\program files (x86)\microsoft Office2003\Office11\Excel.exe" /unregserver
>>>> "c:\program files (x86)\microsoft Office\Office14\Excel.exe" /unregserver
>>>> rem Then enter this to specify the default version...
>>>> "c:\program files (x86)\microsoft Office\Office14\Excel.exe" /regserver
>>>>
>>>> Sincerely,
>>>> Lynn McGuire
>>>
>>> Interestingly, I was able to change from XL2007 to XL2003, but I can't seem to change back to XL2007. Have you been able to switch
>>> back&forth?

>>
>> Yes. Between 203 and 2010. Make sure that your programs paths
>> in those batch files are absolutely correct.
>>
>> Lynn

>
> Strange! The paths are identical except for the version number since they're all installed under the same main folder...
>
> "C:\Program Files\Microsoft Office\Office11\Office11\Excel.exe"
> "C:\Program Files\Microsoft Office\Office12\Office12\Excel.exe"


You need to reinstall one of them in a separate path. Look at the
paths of mine:

c:\program files (x86)\microsoft Office2003\Office11\Excel.exe
c:\program files (x86)\microsoft Office\Office14\Excel.exe

I put my Excel 2003 into "c:\program files (x86)\microsoft Office2003".

Lynn

 
Reply With Quote
 
GS
Guest
Posts: n/a
 
      20th Apr 2011
It happens that Lynn McGuire formulated :
> On 4/19/2011 7:44 PM, GS wrote:
>> Lynn McGuire brought next idea :
>>> On 4/19/2011 4:36 PM, GS wrote:
>>>> Lynn McGuire has brought this to us :
>>>>> How to change between Excel 2003 and 2010 as default on your pc
>>>>> (note excel 2003 must be installed in a special directory so
>>>>> that it does not overwrite excel 2010 files):
>>>>>
>>>>> excel2003.bat
>>>>>
>>>>> rem Enter this first to disassociate an excel version...
>>>>> "c:\program files (x86)\microsoft Office2003\Office11\Excel.exe"
>>>>> /unregserver
>>>>> "c:\program files (x86)\microsoft Office\Office14\Excel.exe"
>>>>> /unregserver
>>>>> rem Then enter this to specify the default version...
>>>>> "c:\program files (x86)\microsoft Office2003\Office11\Excel.exe"
>>>>> /regserver
>>>>>
>>>>> excel2010.bat
>>>>>
>>>>> rem Enter this first to disassociate an excel version...
>>>>> "c:\program files (x86)\microsoft Office2003\Office11\Excel.exe"
>>>>> /unregserver
>>>>> "c:\program files (x86)\microsoft Office\Office14\Excel.exe"
>>>>> /unregserver
>>>>> rem Then enter this to specify the default version...
>>>>> "c:\program files (x86)\microsoft Office\Office14\Excel.exe" /regserver
>>>>>
>>>>> Sincerely,
>>>>> Lynn McGuire
>>>>
>>>> Interestingly, I was able to change from XL2007 to XL2003, but I can't
>>>> seem to change back to XL2007. Have you been able to switch
>>>> back&forth?
>>>
>>> Yes. Between 203 and 2010. Make sure that your programs paths
>>> in those batch files are absolutely correct.
>>>
>>> Lynn

>>
>> Strange! The paths are identical except for the version number since
>> they're all installed under the same main folder...
>>
>> "C:\Program Files\Microsoft Office\Office11\Office11\Excel.exe"
>> "C:\Program Files\Microsoft Office\Office12\Office12\Excel.exe"

>
> You need to reinstall one of them in a separate path. Look at the
> paths of mine:
>
> c:\program files (x86)\microsoft Office2003\Office11\Excel.exe
> c:\program files (x86)\microsoft Office\Office14\Excel.exe
>
> I put my Excel 2003 into "c:\program files (x86)\microsoft Office2003".
>
> Lynn


--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


 
Reply With Quote
 
GS
Guest
Posts: n/a
 
      20th Apr 2011
on 4/20/2011, Lynn McGuire supposed :
> On 4/19/2011 7:44 PM, GS wrote:
>> Lynn McGuire brought next idea :
>>> On 4/19/2011 4:36 PM, GS wrote:
>>>> Lynn McGuire has brought this to us :
>>>>> How to change between Excel 2003 and 2010 as default on your pc
>>>>> (note excel 2003 must be installed in a special directory so
>>>>> that it does not overwrite excel 2010 files):
>>>>>
>>>>> excel2003.bat
>>>>>
>>>>> rem Enter this first to disassociate an excel version...
>>>>> "c:\program files (x86)\microsoft Office2003\Office11\Excel.exe"
>>>>> /unregserver
>>>>> "c:\program files (x86)\microsoft Office\Office14\Excel.exe"
>>>>> /unregserver
>>>>> rem Then enter this to specify the default version...
>>>>> "c:\program files (x86)\microsoft Office2003\Office11\Excel.exe"
>>>>> /regserver
>>>>>
>>>>> excel2010.bat
>>>>>
>>>>> rem Enter this first to disassociate an excel version...
>>>>> "c:\program files (x86)\microsoft Office2003\Office11\Excel.exe"
>>>>> /unregserver
>>>>> "c:\program files (x86)\microsoft Office\Office14\Excel.exe"
>>>>> /unregserver
>>>>> rem Then enter this to specify the default version...
>>>>> "c:\program files (x86)\microsoft Office\Office14\Excel.exe" /regserver
>>>>>
>>>>> Sincerely,
>>>>> Lynn McGuire
>>>>
>>>> Interestingly, I was able to change from XL2007 to XL2003, but I can't
>>>> seem to change back to XL2007. Have you been able to switch
>>>> back&forth?
>>>
>>> Yes. Between 203 and 2010. Make sure that your programs paths
>>> in those batch files are absolutely correct.
>>>
>>> Lynn

>>
>> Strange! The paths are identical except for the version number since
>> they're all installed under the same main folder...
>>
>> "C:\Program Files\Microsoft Office\Office11\Office11\Excel.exe"
>> "C:\Program Files\Microsoft Office\Office12\Office12\Excel.exe"

>
> You need to reinstall one of them in a separate path. Look at the
> paths of mine:
>
> c:\program files (x86)\microsoft Office2003\Office11\Excel.exe
> c:\program files (x86)\microsoft Office\Office14\Excel.exe
>
> I put my Excel 2003 into "c:\program files (x86)\microsoft Office2003".
>
> Lynn


Hi Lynn,
They already are in separate paths! I don't think by reinstalling to a
folder with a different name is going to change anything. Clearly...

~\Office11\Office11\Excel.exe
is different than...
~\Office12\Office12\Excel.exe

Besides, having to do that defeats the purpose of using batch files!<g>

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import Excel 2010 table into Access 2010 - not listed as range rob11marmion@gmail.com Microsoft Access External Data 1 17th Feb 2013 11:04 PM
Excel 2010 Table not showing in Access 2010 Import List rob11marmion@gmail.com Microsoft Excel Discussion 0 21st Dec 2012 06:22 AM
Form 4 Range of time from 1/20/2010 4:00 AM To 1/21/2010 10:00 AM Peter Gonzalez Microsoft Excel Worksheet Functions 2 26th Jan 2010 07:58 PM
Can't open workbook in excel 64 bit 2010 - but can in excel 2010 3 Darrell Microsoft Excel Programming 5 12th Jan 2010 10:03 PM
Office 2010 & Outlook 2010 and Business Contact Manager AvrahamC Microsoft Outlook BCM 0 4th Jan 2010 02:56 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:35 PM.