VBA, Calling functions/subs using the string title

Calling functions/subs using the string title - possible?

Author	Message
Andy Heal #1 / 4	Calling functions/subs using the string title - possible? Might be dumb-ass question and the answer is probably staring me in the face but... Suppose I had a table as below... Functions --------- test1 test2 test3 and so on... where test1, test2 and test3 refer to actual functions I want to run. I would like to run through a recordset loop calling each function in turn. Obivously, I can't use Call rst![Functions] and I'm out of ideas! Any pointers would be appreciated. Thanks, Andy.
Sat, 24 May 2003 03:00:00 GMT

Hans-Chr. Franck #2 / 4	Calling functions/subs using the string title - possible? Look for help on the Eval() function. That should do what you ask -- Regards Hans-Chr. Francke www.master-office.com Quote: > Might be dumb-ass question and the answer is probably staring me in the face > but... > Suppose I had a table as below... > Functions > --------- > test1 > test2 > test3 > and so on... > where test1, test2 and test3 refer to actual functions I want to run. > I would like to run through a recordset loop calling each function in turn. > Obivously, I can't use Call rst![Functions] and I'm out of ideas! > Any pointers would be appreciated. > Thanks, > Andy.
Sat, 24 May 2003 03:00:00 GMT

roma #3 / 4	Calling functions/subs using the string title - possible? ...but remember that eval() only evaluates, it doesn't execute code as such. Therefore the functions you call must be Public Functions, _NOT_ Subs. -- Rob McClean "...a Saviour has been born to you in David's city, who is Christ the Lord." The Holy Bible, Luke ch 2 v 11 Quote: > Might be dumb-ass question and the answer is probably staring me in the face > but... > Suppose I had a table as below... > Functions > --------- > test1 > test2 > test3 > and so on... > where test1, test2 and test3 refer to actual functions I want to run. > I would like to run through a recordset loop calling each function in turn. > Obivously, I can't use Call rst![Functions] and I'm out of ideas! > Any pointers would be appreciated. > Thanks, > Andy.
Sat, 24 May 2003 03:00:00 GMT

Flavio Mian #4 / 4	Calling functions/subs using the string title - possible? how to do the pasto picture to a filename by eval ???? thanks Flavio Hans-Chr. Francke ha scritto nel messaggio ... Quote: >Look for help on the Eval() function. That should do what you ask >-- >Regards Hans-Chr. Francke >www.master-office.com >> Might be dumb-ass question and the answer is probably staring me in the >face >> but... >> Suppose I had a table as below... >> Functions >> --------- >> test1 >> test2 >> test3 >> and so on... >> where test1, test2 and test3 refer to actual functions I want to run. >> I would like to run through a recordset loop calling each function in >turn. >> Obivously, I can't use Call rst![Functions] and I'm out of ideas! >> Any pointers would be appreciated. >> Thanks, >> Andy.
Sun, 20 Jul 2003 20:06:25 GMT

Page 1 of 1

[ 4 post ]