how to change between Excel 2003 and 2010 as default

Discussion in 'Microsoft Excel Discussion' started by Lynn McGuire, Apr 18, 2011.

  1. Lynn McGuire

    Lynn McGuire Guest

    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
     
    Lynn McGuire, Apr 18, 2011
    #1
    1. Advertisements

  2. Lynn McGuire

    GS Guest

    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
     
    GS, Apr 18, 2011
    #2
    1. Advertisements

  3. Lynn McGuire

    Lynn McGuire Guest

    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
     
    Lynn McGuire, Apr 18, 2011
    #3
  4. Lynn McGuire

    GS Guest

    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
     
    GS, Apr 19, 2011
    #4
  5. Lynn McGuire

    Lynn McGuire Guest

    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
     
    Lynn McGuire, Apr 20, 2011
    #5
  6. Lynn McGuire

    GS Guest

    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
     
    GS, Apr 20, 2011
    #6
  7. Lynn McGuire

    Lynn McGuire Guest

    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
     
    Lynn McGuire, Apr 20, 2011
    #7
  8. Lynn McGuire

    GS Guest

    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
     
    GS, Apr 20, 2011
    #8
  9. Lynn McGuire

    GS Guest

    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
     
    GS, Apr 20, 2011
    #9
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Lynn McGuire

    can I use both Excel 2003 and Excel 2010 on the same pc ?

    Lynn McGuire, Nov 30, 2010, in forum: Microsoft Excel Discussion
    Replies:
    12
    Views:
    20,965
    Lynn McGuire
    Dec 8, 2010
  2. clucom
    Replies:
    0
    Views:
    659
    clucom
    May 2, 2012
  3. Replies:
    0
    Views:
    656
  4. Bobby
    Replies:
    1
    Views:
    327
    Bobby
    Jan 16, 2013
  5. Replies:
    0
    Views:
    511
Loading...

Share This Page