passing variables

I have an Access program that was written by someone else that needs to call a VB program written by me. The Acess program needs to pass some variables to the VB program and the VB program needs to return 2 variables. Is there any way to do this? I know I could create a temporary table with the data, have the VB program retrieve, then have the VB program return variables the same way, but can it be done by simply passing the variables between the two?
[458 byte] By [megageekgirl] at [2007-11-15 17:37:46]
# 1 Re: passing variables
if you compile the vb program into a dll with public interfaces (ie: a function w/ return parameters), you can use the ado command object w/ defined parameters inside access. hope that helps.
sf_everlast at 2007-11-10 0:43:58 >