Excel, Com, XLL and .Net
 

Hi,

Trying to figure out what is the best way to code up my add-in.

The addin will require to "push-back" into excel.

Any CommentS?

Excel, Com, XLL and .Net
 

If you are going to write code to push data into Excel and are using Excel
2002 and above then I would recommend using an Excel RTD component. That
will be a .dll or a .exe and can be in vb6, c++ etc.

Have a look on MSDN for some example of an RTD server - it's good for
pushing data into excel using a hybrid push/pull mechanism.

You can write the RTD component in a .NET language and create an interop,
but I cannot comment on how that works (not tried myself)

I would not recommend writing an XLL - it's not really the MS way forwards.

Good luck.
--
www.alignment-systems.com


" wrote:

Hi,

Trying to figure out what is the best way to code up my add-in.

The addin will require to "push-back" into excel.

Any CommentS?

Excel, Com, XLL and .Net
 

Please comment on "the way forward". What is "the way forward". This will
help me to decide on a development platform for Excel add-ins.

I can then ask, what is the best platform to develop Excel add-ins?

Thanks


"John.Greenan" wrote:

If you are going to write code to push data into Excel and are using Excel
2002 and above then I would recommend using an Excel RTD component. That
will be a .dll or a .exe and can be in vb6, c++ etc.

Have a look on MSDN for some example of an RTD server - it's good for
pushing data into excel using a hybrid push/pull mechanism.

You can write the RTD component in a .NET language and create an interop,
but I cannot comment on how that works (not tried myself)

I would not recommend writing an XLL - it's not really the MS way forwards.

Good luck.
--
www.alignment-systems.com


" wrote:

Hi,

Trying to figure out what is the best way to code up my add-in.

The addin will require to "push-back" into excel.

Any CommentS?