I am sry. I should have explained in a better way.
I have user defined functions on SQL server 2000. I need to call it from my VBA by supplying some parameters. Can anyone tell me how I can do it.
Also when I write user defined functions on SQL server 2000, do I have to store it at a specific place( for ex in the data sub folder of SQL Server).
Any help is greatly appreciated