PC Review


Reply
Thread Tools Rate Thread

C#/Excel automation add-in not working on MediaCenter?

 
 
My interest
Guest
Posts: n/a
 
      27th Jan 2007
I have written a simple Excel automation add-in using c#. It works
fine on my WinXP PC, but does not work on my MediaCenter PC. The
sympton is that the add-in is shown in the add-in list but all the
functions are not available (i.e. when you open the function help
dialoug, these functions are not displayed, actually even the assembly
is not shown in the category.)

I have tried (1) recompile the code on the MediaCenter, (2) manually
register the code compiled on XP, (3) run a setup program created using
visual studio. None of them worked.

I guess there may be something specific on the MediaCenter machine or
some Excel configuration (e.g. security etc). But I just couldn't
figure it out. Any suggestions and recommendations, or even wildest
guess, are welcomed.

My environment: Visual Studio 2005, Excel 2003

 
Reply With Quote
 
 
 
 
My interest
Guest
Posts: n/a
 
      27th Jan 2007
BTW, I have also tried sign my assembly, didn't work either.

 
Reply With Quote
 
Robson Siqueira
Guest
Posts: n/a
 
      27th Jan 2007
My interest,

I would rather point the fingers to the environment. Did you verify if all
support assemblies you are using - or COM objects - are properly installed
and have the same version as you have on the XP machine.

In fact, Media Center it's almost the same Windows (to not say the same) as
the XP. It only has the Media Center application added to the system. As
well as a notepad application.

If you are using VSTO, make sure everything looks the same as your XP
machine.

I hope it helps.

--
Regards,
Robson Siqueira
Enterprise Architect
"My interest" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have written a simple Excel automation add-in using c#. It works
> fine on my WinXP PC, but does not work on my MediaCenter PC. The
> sympton is that the add-in is shown in the add-in list but all the
> functions are not available (i.e. when you open the function help
> dialoug, these functions are not displayed, actually even the assembly
> is not shown in the category.)
>
> I have tried (1) recompile the code on the MediaCenter, (2) manually
> register the code compiled on XP, (3) run a setup program created using
> visual studio. None of them worked.
>
> I guess there may be something specific on the MediaCenter machine or
> some Excel configuration (e.g. security etc). But I just couldn't
> figure it out. Any suggestions and recommendations, or even wildest
> guess, are welcomed.
>
> My environment: Visual Studio 2005, Excel 2003
>



 
Reply With Quote
 
My interest
Guest
Posts: n/a
 
      27th Jan 2007
Finally I figured it out. It's because excel.exe.config is missing so
Excel does not recognize .NET 2.0 based Add-In and has silently failed
to load my Add-In

On Jan 27, 2:22 pm, "Robson Siqueira" <rob...@robsonfelix.com> wrote:
> My interest,
>
> I would rather point the fingers to the environment. Did you verify if all
> support assemblies you are using - or COM objects - are properly installed
> and have the same version as you have on the XP machine.
>
> In fact, Media Center it's almost the same Windows (to not say the same) as
> the XP. It only has the Media Center application added to the system. As
> well as a notepad application.
>
> If you are using VSTO, make sure everything looks the same as your XP
> machine.
>
> I hope it helps.
>
> --
> Regards,
> Robson Siqueira
> Enterprise Architect"My interest" <myinter...@gmail.com> wrote in messagenews:(E-Mail Removed)...
>
> >I have written a simple Excel automation add-in using c#. It works
> > fine on my WinXP PC, but does not work on my MediaCenter PC. The
> > sympton is that the add-in is shown in the add-in list but all the
> > functions are not available (i.e. when you open the function help
> > dialoug, these functions are not displayed, actually even the assembly
> > is not shown in the category.)

>
> > I have tried (1) recompile the code on the MediaCenter, (2) manually
> > register the code compiled on XP, (3) run a setup program created using
> > visual studio. None of them worked.

>
> > I guess there may be something specific on the MediaCenter machine or
> > some Excel configuration (e.g. security etc). But I just couldn't
> > figure it out. Any suggestions and recommendations, or even wildest
> > guess, are welcomed.

>
> > My environment: Visual Studio 2005, Excel 2003


 
Reply With Quote
 
Frank Rizzo
Guest
Posts: n/a
 
      28th Jan 2007
Robson Siqueira wrote:
> My interest,
>
> I would rather point the fingers to the environment. Did you verify if all
> support assemblies you are using - or COM objects - are properly installed
> and have the same version as you have on the XP machine.
>
> In fact, Media Center it's almost the same Windows (to not say the same) as
> the XP. It only has the Media Center application added to the system. As
> well as a notepad application.


I don't think that is the case entirely. There are other things added
to the system, typically by integrators such as dell. My system came
with way too many extra MCE add-ins. Those add-ins could potentially
introduce incompatibilities.

And of course, MCE comes with .NET framework.

Regards
 
Reply With Quote
 
My interest
Guest
Posts: n/a
 
      28th Jan 2007
I am not a Microsoft insider. But what I heard was, the different
version of Windows all had the same binary code. The only difference
is the configuration (e.g. during the installation, registry etc)

On Jan 27, 9:06 pm, Frank Rizzo <n...@none.net> wrote:
> Robson Siqueira wrote:
> > My interest,

>
> > I would rather point the fingers to the environment. Did you verify if all
> > support assemblies you are using - or COM objects - are properly installed
> > and have the same version as you have on the XP machine.

>
> > In fact, Media Center it's almost the same Windows (to not say the same) as
> > the XP. It only has the Media Center application added to the system. As
> > well as a notepad application.I don't think that is the case entirely. There are other things added

> to the system, typically by integrators such as dell. My system came
> with way too many extra MCE add-ins. Those add-ins could potentially
> introduce incompatibilities.
>
> And of course, MCE comes with .NET framework.
>
> Regards


 
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
Working with Timesheets and getting code to get automation working... al2k Microsoft Excel Worksheet Functions 1 17th Sep 2008 12:37 PM
Access automation leaves Excel open which in turn locks 2nd automation attempts EagleOne@discussions.microsoft.com Microsoft Access 8 30th Jun 2008 01:27 AM
Vista mediacenter versus vista mediacenter extender Torben Broendum Windows Vista General Discussion 0 7th Apr 2008 01:30 PM
C#/Excel automation add-in not working on MediaCenter? My interest Microsoft C# .NET 3 28th Jan 2007 02:06 AM
error working with excel automation in asp.net Ramakrishna Microsoft Excel Crashes 0 4th Dec 2003 04:17 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:36 AM.