Call a procedure using a variable
 

Is there a way to call a procedure using a variable? I tried

Call reportname & "Report"

reportname is a string variable. I got a error when I tried this.
Thanks

Call a procedure using a variable
 

application.run reportname & "Report"



ranswrt wrote:

Is there a way to call a procedure using a variable? I tried

Call reportname & "Report"

reportname is a string variable. I got a error when I tried this.
Thanks

--

Dave Peterson

Call a procedure using a variable
 

Whatever you use after the word "Call" must equate to the procedure name
only, with any arguments place in parentheses.
myProcedure = DoASort
Call myProcedure(Range("A1:A100")

Unless the concatenated word is part of the name, it will throw an error.

"ranswrt" wrote:

Is there a way to call a procedure using a variable? I tried

Call reportname & "Report"

reportname is a string variable. I got a error when I tried this.
Thanks

Call a procedure using a variable
 

Thank You

"Dave Peterson" wrote:

application.run reportname & "Report"



ranswrt wrote:

Is there a way to call a procedure using a variable? I tried

Call reportname & "Report"

reportname is a string variable. I got a error when I tried this.
Thanks

--

Dave Peterson