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

Hello Andrew
How about:
Application.Run strProcedureName

HTH
Cordially
Pascal

"Andrew" <(E-Mail Removed)> a écrit dans le message de news:
(E-Mail Removed)...
> 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
>

On 4 Oct, 13:03, "papou" <cpapoupasbon@çanonpluslaposte.net> wrote:
> Hello Andrew
> How about:
> Application.Run strProcedureName
>
> HTH
> Cordially
> Pascal
>
> "Andrew" <andrewmricha...@yahoo.co.uk> a écrit dans le message de news:
> 1191498994.693645.288...@g4g2000hsf.googlegroups.com...
>
>
>
> > 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