Search results

Correct, they are string variables, except where noted, such as ProjStatus being Boolean. I don't think I followed your questions and got confused on the terminology

Even as a sub routine, I cannot pass the parameters. I get an error that says" cannot find procedure 'main(parentName,.....

I might have just found the issue. Main is a function, not a sub. Could this be the problem? below are the parameter types, hierarhcy() is a string: Function main(dte As Date, parentName$, RESPORG$, UNIT$, lvl$, hierarchy() As String, PERF#, date_list As Object, ProjStatus As Boolean, ProjDate...

they are text, and all required inputs for the sub main to know what to do

10 parameters. here is what I tried to do: accapp.Run "main(parentName, RESPORG, UNIT, level, hierarchy(), expectedPerf, date_list, ProjStatus, ProjDate, NTIMS_STATUS)"

It is calling a sub routine. 'main' is the name of the sub.

I am trying to open an access database from another database and run a macro in it. I can accomplish this, but I also need to pass variables into the other database's macro for it to run appropriatly. DB 1: user makes selection on user form and they are stored as variables - macro opens DB2 and...