View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.sdk
John.Greenan John.Greenan is offline
external usenet poster
 
Posts: 175
Default 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?