OpenEuphoria

Re: Excel

• Posted by Mike777 <anon4321 at g?ail.co?> Jan 08, 2008
• 1680 views

Matt Lewis wrote:
> 
> Mike777 wrote:
> > 
> > I figured this time I would ask first! Has anybody a good link/reference for
> > building a DLL that can function as an Excel Add-in?  Not critical.  Not
> > rush.
> > Just something I have my sights set on.
> 
> I suspect that your dll needs to be an ActiveX object, which implies a lot
> of overhead.  There are probably templates that can be used from C++ or 
> maybe some .NET language, but I'm not aware of anyone building an ActiveX 
> object in euphoria.  I think it's possible, but would be very difficult,
> at least the first time.

I'm not sure I need to go the ActiveX route.  My understanding is that you only
need/want ActiveX is you want to go outside of the Excel framework.  For example,
if you want to write to or read directly from the file system.  If all you want
to do is memory bound, I think an Add-in can be compiled as a special form of
DLL.  I remember some KB articles on it the last time I looked, which was quite a
while ago (I told you it wasn't a rush!).  Now that I've at least posted here,
I'll see if I can't find something that lays out the requirements as far as how
the DLL has to be built.

Mike