xla written in C#

Hi

Can anyone tell me if it is possible to write a xla in C# instead of VBA?

Thanks Torben

A COM addin probably but not a xla.

--
HTH

Bob Phillips

"Torben Laursen" <does@not.work> wrote in message
news:uV9quENmFHA.708@TK2MSFTNGP10.phx.gbl...
> Hi
>
> Can anyone tell me if it is possible to write a xla in C# instead of VBA?
>
> Thanks Torben
>
>

Torben
An XLA is pretty much just a hidden workbook with VBA code. You can't
create these in C#. You can do COM addins and automation addins (for UDFs)
in .net.

cheers
Simon

"Torben Laursen" wrote:

> Hi
>
> Can anyone tell me if it is possible to write a xla in C# instead of VBA?
>
> Thanks Torben
>
>
>

Thanks

What about Visual studio 2005 tools for office, does it offer a good
replacment for a xla?
Maybe something that I can put on a server so nothing has to be installed on
any PC?

Only request is that the user can access the code using a function call
inside excel

Torben

"Simon Murphy" <SimonMurphy@discussions.microsoft.com> wrote in message
news:AC66616F-CB03-4C03-95D8-AE4342E79FB0@microsoft.com...
> Torben
> An XLA is pretty much just a hidden workbook with VBA code. You can't
> create these in C#. You can do COM addins and automation addins (for
> UDFs)
> in .net.
>
> cheers
> Simon
>
> "Torben Laursen" wrote:
>
>> Hi
>>
>> Can anyone tell me if it is possible to write a xla in C# instead of VBA?
>>
>> Thanks Torben
>>
>>
>>

Torben
Whether a VBA xla addin or a vb6.0 Com addin or a .net com or automation
addin or an XLL toally depends on what you are doing.

If you are server side and you want to avoid Excel on the server (and you
should) then a standard COM component or a .net assembly will prob be best.
you can call these from a VBA wrapper by setting a reference. Or as you say
use a VSTO solution - these are available in VS 2003 and the beta 2005 ones
are supported now for deployment.

The choice depends on how much use of Excel/.net you need, how much future
proofing you need, if all clients have xl2003 etc etc.

cheers
Simon


"Torben Laursen" wrote:

> Thanks
>
> What about Visual studio 2005 tools for office, does it offer a good
> replacment for a xla?
> Maybe something that I can put on a server so nothing has to be installed on
> any PC?
>
> Only request is that the user can access the code using a function call
> inside excel
>
> Torben
>
> "Simon Murphy" <SimonMurphy@discussions.microsoft.com> wrote in message
> news:AC66616F-CB03-4C03-95D8-AE4342E79FB0@microsoft.com...
> > Torben
> > An XLA is pretty much just a hidden workbook with VBA code. You can't
> > create these in C#. You can do COM addins and automation addins (for
> > UDFs)
> > in .net.
> >
> > cheers
> > Simon
> >
> > "Torben Laursen" wrote:
> >
> >> Hi
> >>
> >> Can anyone tell me if it is possible to write a xla in C# instead of VBA?
> >>
> >> Thanks Torben
> >>
> >>
> >>
>
>
>