Passing parameters to External Applications

C

cwatchowski

I have created a form with 6 combo boxes. They all display data from
specific table and allow the user to chose one from each. After the
have selected all 6, they click on an "UPDATE" button and I start
VBScript program using the RunApp function. My problem is that I nee
to pass the 6 combo box selections to this VBScript. Can this be don
and, if so, how do I do it
 
P

peter walker

You have to host the vbscripting engine dll in access. The is some stuff you
can google up about using it with VBA / VB. I yve used it in access more as
an expriment or 'solution looking for a problem'
It worked well enough but I was hard pressed to find any use for VB Script
compared to what I can do with a PC just using VBA.

hth
peter walker
 
R

rkc

cwatchowski said:
I have created a form with 6 combo boxes. They all display data from a
specific table and allow the user to chose one from each. After they
have selected all 6, they click on an "UPDATE" button and I start a
VBScript program using the RunApp function. My problem is that I need
to pass the 6 combo box selections to this VBScript. Can this be done
and, if so, how do I do it ?
Click to expand...

Write the values to a file and then read the file from the vbscript program.
 
C

cwatchowski

rkc said:
Write the values to a file and then read the file from the vbscrip
program.
Click to expand...

Can you tell me how to do this? I have tried the "OutputTo" action bu
I only get the form and not the data
 
Top