>FUNCTION SomeMethod(ParamASString) AS Void ;
> HELPSTRING "Description of method"
>
> * Code here
>ENDFUNC
>
Yeah, that works, Thx.
>>Bonus question. Considering they will be using these functions (in the DLL) as Excel functions, therefore sometimes recalculated in hundreds of rows, sometimes not at all for periods of time, would it better to maintain an open connection once in the DLL (in INIT) or to connect/disconnect in each Function/Procedure? Not sure about this one. Timing woul dbe faster with an open connection to SQL Server (through our LAN), but I'm not happy with 10 or so users haviong open connections for long periods of time dutring the workday. >> > >I depends on the scenario, but from what you've described, I would probably open/close in each method. It will be safer (since you'd need to ensure a connection was still valid anyway).
I had already come to that conclusion in the interim. Thx.
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry