>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

Once you have the object reference, you should be able to everything you need from within VFP. What are you trying to do?