| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Reregister a given Excel version
Hi
SITUATION... Two Excel version 11.0 and 12.0 are installed on a subset of machines... Depending on the last update made, one or the other is declared as the default Excel to be launch... This can be seen in the following registry key... HKEY_CLASSES_ROOT\Excel.Application\CurVer that can equal to Excel.Application.12 or to Excel.Application.11 Manifestly, only a reregistration of a given excel version can reestablish an expected situation such as havin version 12.0 being the default one... QUESTION... How can I run a "LIGHT" Reregistration of Excel 12.0 through a script launched at login time ? and this without being forced to run an Office reparation... Is this possible through some registry key manipulations ? Thanks for your help Regards Alain |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Reregister a given Excel version
How about having a .bat file run when pulling up Excel that registers the
'proper' Excel... 'To UnRegister Excel: ' 1) Close Excel ' 2) Windows Start Button ' 3) Run ' 4) Excel /unregserver 'To Register Excel: ' 1) Close Excel ' 2) Windows Start Button ' 3) Run ' 4) Excel /regserver where 'Excel' includes the appropriate file path. -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Desaivres Alain" wrote: Hi SITUATION... Two Excel version 11.0 and 12.0 are installed on a subset of machines... Depending on the last update made, one or the other is declared as the default Excel to be launch... This can be seen in the following registry key... HKEY_CLASSES_ROOT\Excel.Application\CurVer that can equal to Excel.Application.12 or to Excel.Application.11 Manifestly, only a reregistration of a given excel version can reestablish an expected situation such as havin version 12.0 being the default one... QUESTION... How can I run a "LIGHT" Reregistration of Excel 12.0 through a script launched at login time ? and this without being forced to run an Office reparation... Is this possible through some registry key manipulations ? Thanks for your help Regards Alain |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Reregister a given Excel version
No doubt in theory it's possible to register via the registry, but would
probably need to unregister Excel 2003 first, Then a lot of work. From the command line you could do "C:\pathToXL2007\excel.exe" /regserver or similar with Shell (note you'll probably need double quotes around the path) I very much doubt you'll want to do this on each login time, at most if/as necessary which should be only very rarely (you can get the CurVer from the registry). Regards, Peter T "Desaivres Alain" wrote in message ... Hi SITUATION... Two Excel version 11.0 and 12.0 are installed on a subset of machines... Depending on the last update made, one or the other is declared as the default Excel to be launch... This can be seen in the following registry key... HKEY_CLASSES_ROOT\Excel.Application\CurVer that can equal to Excel.Application.12 or to Excel.Application.11 Manifestly, only a reregistration of a given excel version can reestablish an expected situation such as havin version 12.0 being the default one... QUESTION... How can I run a "LIGHT" Reregistration of Excel 12.0 through a script launched at login time ? and this without being forced to run an Office reparation... Is this possible through some registry key manipulations ? Thanks for your help Regards Alain |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Reregister a given Excel version
Hi
In fact I have found that solution "C:\pathToXL2007\excel.exe" /regserver but on my machine - it works perfectly with the Excel.exe of 2003 version - but not with the excel.exe of 2007 in the first case HKEY_CLASSES_ROOT\Excel.Application\CurVer move from Excel.Application.12 to Excel.Application.A11 = perfect... Excel is not opened, just some small installation windows... Unfortunately - In the second case excel open and nothing hapen regarding the default excel which stay to Excel.Application.11 Any idea ? Thanks and Regards Alain |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Reregister a given Excel version
Yes Gary...
This is "the" idea unfortunately works for Excel 2003 but not for Excel 2007... Any additional peace of advice will be appreciated Thanks and regards Alain |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Reregister a given Excel version
Not sure why that's not working fully. Maybe first try
"C:\pathToXL2003\excel.exe" /unregserver One thing, which version was installed first. Very important to install in order oldest to newest. If you installed 2007 first then 2003, I think it would be a good idea uninstall 2007 completely (maybe re-register 2003) then reinstall 2007. Regards, Peter T "Desaivres Alain" wrote in message ... Hi In fact I have found that solution "C:\pathToXL2007\excel.exe" /regserver but on my machine - it works perfectly with the Excel.exe of 2003 version - but not with the excel.exe of 2007 in the first case HKEY_CLASSES_ROOT\Excel.Application\CurVer move from Excel.Application.12 to Excel.Application.A11 = perfect... Excel is not opened, just some small installation windows... Unfortunately - In the second case excel open and nothing hapen regarding the default excel which stay to Excel.Application.11 Any idea ? Thanks and Regards Alain |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Reregister a given Excel version
Peter
In fact I guess the version installed first doesn't worth being known that much because as soon as a windows update concerning one or the other is run on the machine, the default Excel can change. It's more or less equivalent to a new installation and then the concerned Excel become the dafault one... I have seen that not later than yesterday evening having version 12.0 as default, then running a Windows update concerning Excel 2003 then having version 11.0 as default... I have tried what you suggest also, I mean running an /unregserver before launching a /regserver on Excel 2007 but doesn't change anything... When I launch excel.exe /regserver on Excel 2007, in fact Excel open and does not much care about the switch /regserver as if this switch was not part of swiches known per Excel 2007... I have found several sites where Excel 2k7 switches are listed and /regserver is not part of the list... http://www.investintech.com/images/a...e_Excel_07.pdf http://office.microsoft.com/en-us/ex...580301033.aspx Available switches seems to be /r /t /n /e /p /s /safemode /m /a progID Any additional peace of advice will be appreciated... Have a good day Regards Alain |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Reregister a given Excel version
I understand why you say the installation order is not relevant. Even so
from what I believe the order is important. Not sure with 2007 but in the past installing in the wrong order cannot be fixed simply by re-registering the latest version. Yes you are right, it seems (un)regserver have been removed from the list of switches in 2007, I will enquire. Regards, Peter T "Desaivres Alain" wrote in message ... Peter In fact I guess the version installed first doesn't worth being known that much because as soon as a windows update concerning one or the other is run on the machine, the default Excel can change. It's more or less equivalent to a new installation and then the concerned Excel become the dafault one... I have seen that not later than yesterday evening having version 12.0 as default, then running a Windows update concerning Excel 2003 then having version 11.0 as default... I have tried what you suggest also, I mean running an /unregserver before launching a /regserver on Excel 2007 but doesn't change anything... When I launch excel.exe /regserver on Excel 2007, in fact Excel open and does not much care about the switch /regserver as if this switch was not part of swiches known per Excel 2007... I have found several sites where Excel 2k7 switches are listed and /regserver is not part of the list... http://www.investintech.com/images/a...e_Excel_07.pdf http://office.microsoft.com/en-us/ex...580301033.aspx Available switches seems to be /r /t /n /e /p /s /safemode /m /a progID Any additional peace of advice will be appreciated... Have a good day Regards Alain |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Reregister a given Excel version
Thanks Peter
It's rather complicated to find a workaround for the missing switch... Will appreciate in ase you find something about to tell me... Have a good WE Regards Alain |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Reregister a given Excel version
I don't have any good news for you. It's really a problem to fully restore
2007 as the default. You could try File Excel Options Resources run Microsoft Office Diagnostics and Repair (can take a long time) You may find the only way is to fully uninstall then reinstall! As I mentioned earlier, it's important to install in order oldest to newest. Normally you should never need to do this. You mentioned updates that change the CurVer but the only updates (I think) that would change the CurVer are old SP updates, and there are not likely to be any more of these. Regards, Peter T "Desaivres Alain" wrote in message ... Thanks Peter It's rather complicated to find a workaround for the missing switch... Will appreciate in ase you find something about to tell me... Have a good WE Regards Alain |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lightest way to Reregister Excel | Setting up and Configuration of Excel | |||
| How do I save an Excel 97-2003 version or 2007 version for Mac 200 | Excel Discussion (Misc queries) | |||
| Macro - Save an Open Excel Version 4 as current version of Excel | Excel Programming | |||
| Reregister Com Add-ins via vbs | Excel Programming | |||
| Recover earlier version of excel sheet after new version saved? | Excel Discussion (Misc queries) | |||
Linear Mode
