Prev: problem with conditional formatting and VBA (excel 2007)
Next: Ribbon Customisation
From: Peter T on 19 Mar 2010 09:48
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" <DesaivresAlain(a)discussions.microsoft.com> wrote in
message news:A434F656-3F07-4F9F-A245-F23F99928B96(a)microsoft.com...
> 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


From: Desaivres Alain on 19 Mar 2010 11:21
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/articles/excel/Command_line_Excel_07.pdf
http://office.microsoft.com/en-us/excel/HA101580301033.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
From: Peter T on 19 Mar 2010 11:48
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" <DesaivresAlain(a)discussions.microsoft.com> wrote in
message news:37EE2CB0-C225-42E3-A360-49C00105AE00(a)microsoft.com...
> 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/articles/excel/Command_line_Excel_07.pdf
> http://office.microsoft.com/en-us/excel/HA101580301033.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


From: Desaivres Alain on 19 Mar 2010 12:56
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

From: Peter T on 22 Mar 2010 06:49
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" <DesaivresAlain(a)discussions.microsoft.com> wrote in
message news:6C57EC1C-8AF1-4342-9C2A-B7F123AEDE64(a)microsoft.com...
> 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
>


First  |  Prev  | 
Pages: 1 2
Prev: problem with conditional formatting and VBA (excel 2007)
Next: Ribbon Customisation