Is there a way to pass parameters to a VB executable/ VBA macro/ function/ subroutine from within VFP? At this point I'm not picky. What I have tried is the following:

vapobj=createobject("msproject.application")
vapobj.visible=.t.
vapobj.fileopen("fileloc/filename")
vapobj.macro("macroname")

Which works to run a macro that exists in the file I have opened. However, what I need to do is pass it variables to have it do stuff with. I seem to have hit the bottom of the object tree, but I'm not really sure since I'm having real trouble finding documentation. I'm open to any suggestions, solutions, whatever.

TIA!!

Laurisa Watkins
Seattle City Light