I dont think you can do that in VB. Visual Basic is a compiled language. VBA is a scripted language. You can't run a scripted language from a compiled language without some kind of add on. If you were feeling really brave you could compile the function in C and save it out to the database in binary format. As long as it doesn't alter the stack or other registers you might be able to run it. However watch out because it wont run from the data segment which is where it will be extracted to by default.
What I'm thinking though is it might be possible with something like php. Php accepts scripts. So the idea would be to store a php script in the table in string format. Read it out in vb and send it off to php (the executable). Take php's output and do what you want with it. This would be much like shell scripting in Linux.
2
