Use vbScript to run a Sub in MS Access 1

[teach314]

hi - I'm sure this is really straightforward, but I'm missing something.

I need to run a sub in my mdb file using vbScript. The following works perfectly:

dim objAccess
objAccess.OpenCurrentDataBase("C:\Temp\TEST_db.mdb")
objAccess.Run "ProcessData"
objAccess.Quit
set objAccess = nothing

But, I'm having trouble running a Sub that takes an argument. How would I run the Sub ProcessData(25) ? I keep getting the error message "Microsoft Access can't find the procedure 'ProcessData(25)' "

thanks in advance for help.

 

[PHV]

I'd try this:
objAccess.Run "ProcessData", 25

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[teach314]

makes sense!