In Excel 2003, a statement <<Call SomeModule
will do just that and execute the code in <<Sub SomeModule.
Is it possible for the Call statement to comprise a fixed portion
AND a variable something like:-
Call Some & "Variable"
donwb

You don't need to use the Call keyword. You can use only the procedure
name. However, some folks like using Call, so do with it as you like.
Try code like

Sub AAA()
Call SomeOtherProc("abc",123)
' more code
End Sub

' Or

Sub AAA()
SomeOtherProc "abc",123
' more code
End Sub

If you are using the Call statement, you must enclose parameter list
within parentheses. If you do not use Call, you do not use the
parentheses when calling a Sub, since a Sub doesn't return a value.
But if you are calling a Function, you enclose the parameter list in
parentheses. E.g,

Dim V As Variant
V = SomeFunction("abc",123)

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



On Fri, 10 Apr 2009 21:54:52 +0100, "donwb"
wrote:

In Excel 2003, a statement <<Call SomeModule
will do just that and execute the code in <<Sub SomeModule.
Is it possible for the Call statement to comprise a fixed portion
AND a variable something like:-
Call Some & "Variable"
donwb

Chip,

I think what Don wants is to call procedures like
i=1
call test & i

assuming he has
test1
test2
..
..
..
as procedures
"Chip Pearson" wrote:


You don't need to use the Call keyword. You can use only the procedure
name. However, some folks like using Call, so do with it as you like.
Try code like

Sub AAA()
Call SomeOtherProc("abc",123)
' more code
End Sub

' Or

Sub AAA()
SomeOtherProc "abc",123
' more code
End Sub

If you are using the Call statement, you must enclose parameter list
within parentheses. If you do not use Call, you do not use the
parentheses when calling a Sub, since a Sub doesn't return a value.
But if you are calling a Function, you enclose the parameter list in
parentheses. E.g,

Dim V As Variant
V = SomeFunction("abc",123)

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



On Fri, 10 Apr 2009 21:54:52 +0100, "donwb"
wrote:

In Excel 2003, a statement <<Call SomeModule
will do just that and execute the code in <<Sub SomeModule.
Is it possible for the Call statement to comprise a fixed portion
AND a variable something like:-
Call Some & "Variable"
donwb

Hi Chip & Sheeloo

Chip thanks for the input - I'm ok with the with and without parenthesis

But still have the problem.

Sheeloo - you're right - that's what I'm trying to do and I do have Test1 &
Test2

but either the syntax is wrong or it's not possible.

donwb


"Sheeloo" just remove all As... wrote in
message ...
Chip,

I think what Don wants is to call procedures like
i=1
call test & i

assuming he has
test1
test2
.
.
.
as procedures
"Chip Pearson" wrote:


You don't need to use the Call keyword. You can use only the procedure
name. However, some folks like using Call, so do with it as you like.
Try code like

Sub AAA()
Call SomeOtherProc("abc",123)
' more code
End Sub

' Or

Sub AAA()
SomeOtherProc "abc",123
' more code
End Sub

If you are using the Call statement, you must enclose parameter list
within parentheses. If you do not use Call, you do not use the
parentheses when calling a Sub, since a Sub doesn't return a value.
But if you are calling a Function, you enclose the parameter list in
parentheses. E.g,

Dim V As Variant
V = SomeFunction("abc",123)

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



On Fri, 10 Apr 2009 21:54:52 +0100, "donwb"
wrote:

In Excel 2003, a statement <<Call SomeModule
will do just that and execute the code in <<Sub SomeModule.
Is it possible for the Call statement to comprise a fixed portion
AND a variable something like:-
Call Some & "Variable"
donwb

You can use
i = 12
Application.Run "test" & i
to do what you want to do...

See http://support.microsoft.com/kb/171134

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"donwb" wrote:

Hi Chip & Sheeloo

Chip thanks for the input - I'm ok with the with and without parenthesis

But still have the problem.

Sheeloo - you're right - that's what I'm trying to do and I do have Test1 &
Test2

but either the syntax is wrong or it's not possible.

donwb


"Sheeloo" just remove all As... wrote in
message ...
Chip,

I think what Don wants is to call procedures like
i=1
call test & i

assuming he has
test1
test2
.
.
.
as procedures
"Chip Pearson" wrote:


You don't need to use the Call keyword. You can use only the procedure
name. However, some folks like using Call, so do with it as you like.
Try code like

Sub AAA()
Call SomeOtherProc("abc",123)
' more code
End Sub

' Or

Sub AAA()
SomeOtherProc "abc",123
' more code
End Sub

If you are using the Call statement, you must enclose parameter list
within parentheses. If you do not use Call, you do not use the
parentheses when calling a Sub, since a Sub doesn't return a value.
But if you are calling a Function, you enclose the parameter list in
parentheses. E.g,

Dim V As Variant
V = SomeFunction("abc",123)

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



On Fri, 10 Apr 2009 21:54:52 +0100, "donwb"
wrote:

In Excel 2003, a statement <<Call SomeModule
will do just that and execute the code in <<Sub SomeModule.
Is it possible for the Call statement to comprise a fixed portion
AND a variable something like:-
Call Some & "Variable"
donwb

Many thanks Sheeloo for the answer:
that works fine.
Can't find <<Yes to click it,
though I know it's there somewhere.
donwb


"Sheeloo" just remove all As... wrote in
message ...
You can use
i = 12
Application.Run "test" & i
to do what you want to do...

See http://support.microsoft.com/kb/171134

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"donwb" wrote:

Hi Chip & Sheeloo

Chip thanks for the input - I'm ok with the with and without parenthesis

But still have the problem.

Sheeloo - you're right - that's what I'm trying to do and I do have Test1
&
Test2

but either the syntax is wrong or it's not possible.

donwb


"Sheeloo" just remove all As... wrote in
message ...
Chip,

I think what Don wants is to call procedures like
i=1
call test & i

assuming he has
test1
test2
.
.
.
as procedures
"Chip Pearson" wrote:


You don't need to use the Call keyword. You can use only the procedure
name. However, some folks like using Call, so do with it as you like.
Try code like

Sub AAA()
Call SomeOtherProc("abc",123)
' more code
End Sub

' Or

Sub AAA()
SomeOtherProc "abc",123
' more code
End Sub

If you are using the Call statement, you must enclose parameter list
within parentheses. If you do not use Call, you do not use the
parentheses when calling a Sub, since a Sub doesn't return a value.
But if you are calling a Function, you enclose the parameter list in
parentheses. E.g,

Dim V As Variant
V = SomeFunction("abc",123)

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



On Fri, 10 Apr 2009 21:54:52 +0100, "donwb"
wrote:

In Excel 2003, a statement <<Call SomeModule
will do just that and execute the code in <<Sub SomeModule.
Is it possible for the Call statement to comprise a fixed portion
AND a variable something like:-
Call Some & "Variable"
donwb

Yeah, you're right. I missed the boat on that one.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Fri, 10 Apr 2009 14:51:36 -0700, Sheeloo
just remove all As... wrote:

Chip,

I think what Don wants is to call procedures like
i=1
call test & i

assuming he has
test1
test2
.
.
.
as procedures
"Chip Pearson" wrote:


You don't need to use the Call keyword. You can use only the procedure
name. However, some folks like using Call, so do with it as you like.
Try code like

Sub AAA()
Call SomeOtherProc("abc",123)
' more code
End Sub

' Or

Sub AAA()
SomeOtherProc "abc",123
' more code
End Sub

If you are using the Call statement, you must enclose parameter list
within parentheses. If you do not use Call, you do not use the
parentheses when calling a Sub, since a Sub doesn't return a value.
But if you are calling a Function, you enclose the parameter list in
parentheses. E.g,

Dim V As Variant
V = SomeFunction("abc",123)

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



On Fri, 10 Apr 2009 21:54:52 +0100, "donwb"
wrote:

In Excel 2003, a statement <<Call SomeModule
will do just that and execute the code in <<Sub SomeModule.
Is it possible for the Call statement to comprise a fixed portion
AND a variable something like:-
Call Some & "Variable"
donwb

Thanks for your response... I just pointed it out hoping to learn something
new...

Do you think it is appropriate to ask for an 'Yes' response? I have also
asked Rick...

"Chip Pearson" wrote:

Yeah, you're right. I missed the boat on that one.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

I access this News Group thru OutlookExpress
so presumably that's why I don't see "Click Yes"
donwb


"Sheeloo" just remove all As... wrote in
message ...
Thanks for your response... I just pointed it out hoping to learn
something
new...

Do you think it is appropriate to ask for an 'Yes' response? I have also
asked Rick...

"Chip Pearson" wrote:

Yeah, you're right. I missed the boat on that one.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)