Stuart McLachlan
stuart at lexacorp.com.pg
Fri Jan 27 20:51:14 CST 2012
See my other post. I must have thought of application.run at the same time as you were drafting this. GMTA :-) -- Stuart On 27 Jan 2012 at 21:48, William Benson wrote: > I have sometimes put proc names in a table. Run the code required for a > particular value from a group of records selected from the table. I also > added refernce to vba extensibility to the project so that I could loop vbe > components to verify that " "& procname & ")" could be found in the code > project. > > I was just kinda playing around- no real advantage - but I enjoyed > selecting a list of required procs in a recordset according to some > parameters then looping the recordset to call the needed functions in > required sequence, by name using either evaluate() or application.run -- Stuart McLachlan Ph: +675 340 4392 Mob: +675 7100 2028 Web: http://www.lexacorp.com.pg