Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!csd4.milw.wisc.edu!lll-winken!uunet!microsoft!neilh
From: neilh@microsoft.UUCP (Neil Hoopman)
Newsgroups: comp.sys.mac.programmer
Subject: Re: compiling your own Excel(2.2) functions
Message-ID: <7153@microsoft.UUCP>
Date: 28 Jul 89 21:39:38 GMT
References: <8007@spool.cs.wisc.edu>
Reply-To: neilh@microsoft.UUCP (Neil Hoopman)
Organization: Microsoft Corp., Redmond WA
Lines: 41

In article <8007@spool.cs.wisc.edu> engber@thylacine.CS.WISC.EDU writes:
>
>The new version of Excel, 2.2, advertises that you can compile functions
>and import them for use in Excel. Any of the 2.2 owners care to comment?
> - is it documented in the manual (if not how do you get docs)
> - what all is involved 
> - can functions accept/return array arguments
> - can I use LightSpeed Pascal or C or will I need MPW
>
>It sounds like a really nice feature, but I haven't heard anything about it
>except for one sentence in my upgrade letter so I'm suspicious.
>
>-ME

Yes, Excel 2.2 does offer this feature.  For complete documentation,
call Microsoft Product Support at 206-454-2030.  Route to the Macintosh
Applications group, and ask for the "CALL and REGISTER Application Note."

What they'll send you is a complete description of the feature, with
code examples of each of the data types you can pass.

I know that you can use LightSpeed C or MPW C to write the code resources,
but I don't know about LSP (though I don't see any reason why not.)
With the examples, the only thing it entails is writing the C code
resource to perform the function that you want.

Yes, you can accept and return array arguments to code resources.

If there is interest, I can post some of the CALL/REGISTER functions
that I've written as examples.

Have fun!
--Neil

----------------------------------------------------------------------------
Neil Hoopman - Microsoft Corp.                         uunet!microsoft!neilh
------------------------------                  microsoft!neilh@uunet.UU.NET
"Carpe Diem. Seize the day.         microsoft!neilh@beaver.cs.washington.edu
 Make your lives extraordinary."    ----------------------------------------
 - Dead Poets Society                  Neil?  Neil who?  Posted what?  When?
----------------------------------------------------------------------------