View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
 
Posts: 593
Default Excel VBA and SQL Server 2000 UDF

(Charles) wrote ...

Can I get SQL Server 2000 UDF (user defined function) returned value
by using Excel VBA?


Wrap the function in a stored procedure, call the stored proc from VBA
code using ADO.

Jamie.

--