Discussion Article

[ Home | Contents | Search | Reply | Previous | Next ]

Subject:
Creating Dynamic VBA Procedures
Name:
John Wallace
Email (spam proof):
Email the originator of this post
Date:
Friday, April 29, 2005
Hits:
76
Discussion (Terms and Conditions):
I would like to be able call a VBA procedure who's name is stored in a RDMS table eg Table contains3 rows Proc_Priority Proc_Name 1 Sub Proc_1(var1,var2) 2 Sub Proc_2(var1,var2) 3 Sub Proc_3(var1,var2) sCallProc = rsProcTable!Proc_Name Call sCallProc I recall in Delphi there was an inbuilt macro expander called '&' so using Call &sCallProc translated to 'Call Sub Proc_1(var1,var2)' Is anyone aware of how this is possble in VBA

Sponsored by the best FTP application on the internet: