Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable procedure call
Hi,
Does anyone know if I can, during runtime, call a procedure with a variable name? For example, I'd like to pass a parameter to a calling procedure, and then based on that parameter call another procedure. I'm sure I cheat and do it with a select statement, but I'd like to do it more directly if possible. Thanks, Art |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable procedure call
dim myStr as string
mystr = "Sub1" application.run "'" & thisworkbook.name & "'!" & mystr Art wrote: Hi, Does anyone know if I can, during runtime, call a procedure with a variable name? For example, I'd like to pass a parameter to a calling procedure, and then based on that parameter call another procedure. I'm sure I cheat and do it with a select statement, but I'd like to do it more directly if possible. Thanks, Art -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable procedure call
Dave - FANTASTIC!
I really needed to do this, but frankly thought it couldn't be done. I figured I had nothing to lose by asking. This is great! This will really simplify a bunch of stuff in my application. Thanks, Art "Dave Peterson" wrote: dim myStr as string mystr = "Sub1" application.run "'" & thisworkbook.name & "'!" & mystr Art wrote: Hi, Does anyone know if I can, during runtime, call a procedure with a variable name? For example, I'd like to pass a parameter to a calling procedure, and then based on that parameter call another procedure. I'm sure I cheat and do it with a select statement, but I'd like to do it more directly if possible. Thanks, Art -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Call procedure using variable | Excel Programming | |||
Where else to look for procedure call | Excel Programming | |||
can I call a procedure using a variable | Excel Programming | |||
call procedure | Excel Programming | |||
procedure won't call | Excel Programming |