Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call a procedure whose name is stored in a variable
Hi all
Is there a way of calling a procedure, the name of which is stored in a variable? I am trying to create a class object to encapsulate a timer function. The idea is that you would instantiate the object and set a property which determines which procedure to call. Evidently, this property let procedure will use a private string variable to store the information, and so at some point I'll need to have code along the lines of Call [strProcedureName] However, I can't get this to work.... any ideas? Thanks a lot Andrew |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call a procedure whose name is stored in a variable
Hello Andrew
How about: Application.Run strProcedureName HTH Cordially Pascal "Andrew" a écrit dans le message de news: ... Hi all Is there a way of calling a procedure, the name of which is stored in a variable? I am trying to create a class object to encapsulate a timer function. The idea is that you would instantiate the object and set a property which determines which procedure to call. Evidently, this property let procedure will use a private string variable to store the information, and so at some point I'll need to have code along the lines of Call [strProcedureName] However, I can't get this to work.... any ideas? Thanks a lot Andrew |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call a procedure whose name is stored in a variable
On 4 Oct, 13:03, "papou" wrote:
Hello Andrew How about: Application.Run strProcedureName HTH Cordially Pascal "Andrew" a écrit dans le message de news: om... Hi all Is there a way of calling a procedure, the name of which is stored in a variable? I am trying to create a class object to encapsulate a timer function. The idea is that you would instantiate the object and set a property which determines which procedure to call. Evidently, this property let procedure will use a private string variable to store the information, and so at some point I'll need to have code along the lines of Call [strProcedureName] However, I can't get this to work.... any ideas? Thanks a lot Andrew- Hide quoted text - - Show quoted text - Hi Thanks for that. This certainly works so thanks for that. I've another question, regarding calling a proc from Application.OnTime, but it's not really related so I'll do a separate post. Thanks again Andrew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable procedure call | Excel Programming | |||
Call procedure using variable | Excel Programming | |||
How to call a stored procedure in a macro | Excel Programming | |||
Stored Procedure call and passing parameters | Excel Programming | |||
can I call a procedure using a variable | Excel Programming |