Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
call macro with variable
How can I call a macro when the name is a variable
MacroName = "example" While i <= 14 MacroName = MacroName & i Call MacroName (path) i = i + 1 Loop Cheers |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
call macro with variable
Hi
You don't use brackets. Call MacroName or if it has parameters Call MacroName variable1, variable2, etc regards Paul On Apr 2, 10:01*am, Whit wrote: How can I call a macro when the name is a variable * * MacroName = "example" * * While i <= 14 * * * * MacroName = MacroName & i * * * * Call MacroName (path) * * * * i = i + 1 * * Loop Cheers |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
call macro with variable
I get a compile error...
" wrote: Hi You don't use brackets. Call MacroName or if it has parameters Call MacroName variable1, variable2, etc regards Paul On Apr 2, 10:01 am, Whit wrote: How can I call a macro when the name is a variable MacroName = "example" While i <= 14 MacroName = MacroName & i Call MacroName (path) i = i + 1 Loop Cheers |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
call macro with variable
Hi
didn't test this before. Looks like you simply cannot call a variable name macro. I'd suggest you create one macro with a variable parameter Sub myMacro (i as integer) 'code depending on i end sub Then in the loop do Call myMacro i regards Paul On Apr 2, 10:16*am, Whit wrote: I get a compile error... " wrote: Hi You don't use brackets. * * * * Call MacroName or if it has parameters * * * * Call MacroName variable1, variable2, etc regards Paul On Apr 2, 10:01 am, Whit wrote: How can I call a macro when the name is a variable * * MacroName = "example" * * While i <= 14 * * * * MacroName = MacroName & i * * * * Call MacroName (path) * * * * i = i + 1 * * Loop Cheers- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
call macro with variable
Hi,
To my understanding there is no way to call a sub from a name variable. Rather than passing a parameter to a sub with different 'sections' though, wouldn't it be easier to move the 'if' back into the first sub? sub Macro1() Dim NextSub do some things NextSub = whatever you choose Select Case NextSub Case "Macro2" Call Macro2 Case "Macro3" Call Macro3 etc. etc. End Select End Sub Hard to say withouu seeing you code. Cheers, Ivan. On Apr 2, 10:21*pm, wrote: Hi didn't test this before. Looks like you simply cannot call a variable name macro. I'd suggest you create one macro with a variable parameter Sub myMacro (i as integer) * * 'code depending on i end sub Then in the loop do Call myMacro i regards Paul On Apr 2, 10:16*am, Whit wrote: I get a compile error... " wrote: Hi You don't use brackets. * * * * Call MacroName or if it has parameters * * * * Call MacroName variable1, variable2, etc regards Paul On Apr 2, 10:01 am, Whit wrote: How can I call a macro when the name is a variable * * MacroName = "example" * * While i <= 14 * * * * MacroName = MacroName & i * * * * Call MacroName (path) * * * * i = i + 1 * * Loop Cheers- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
call macro with variable
You could use application.run
Option Explicit Sub testme1(mystr As String) MsgBox mystr & " from 1" End Sub Sub testme2(mystr As String) MsgBox mystr & " from 2" End Sub Sub testme3(mystr As String) MsgBox mystr & " from 3" End Sub Sub testme4(mystr As String) MsgBox mystr & " from 4" End Sub Sub aaa() Dim iCtr As Long For iCtr = 1 To 4 Application.Run "testme" & iCtr, "hi there" Next iCtr End Sub Whit wrote: How can I call a macro when the name is a variable MacroName = "example" While i <= 14 MacroName = MacroName & i Call MacroName (path) i = i + 1 Loop Cheers -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Call VBScript from VBA, pass variable, return result to macro? | Excel Programming | |||
Define worksheet as variable, then call in macro | Excel Programming | |||
Call procedure using variable | Excel Programming | |||
can I call a procedure using a variable | Excel Programming | |||
Using variable to call worksheets | Excel Programming |