Is it correct to call a Public Sub w/o enclosing arguments in parentheses?

[MLH]

SendMailPlusWit hOE Subject, Message, Recipients, Files, "08"

I've seen the above syntax used to call the sub SendMailPlusWit hOE

Is it correct/incorrect/good practice/bad practice or just a matter of
personal preference?

[Allen Browne]

It's correct syntax, so it boils down to style.

My presonal preference is to use the Call keyword, and include the brackets.
I find that's more readable and consistent across VBA versions, and the same
syntax works regardless of whether you are calling a Function or Sub, e.g.:
Call Text1_BeforeUpd ate(Cancel)
Call MyFunctionWhere IDontCareAboutR eturnValue(Some Var)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MLH" <CR**@NorthStat e.netwrote in message
news:37******** *************** *********@4ax.c om...

SendMailPlusWit hOE Subject, Message, Recipients, Files, "08"

I've seen the above syntax used to call the sub SendMailPlusWit hOE

Is it correct/incorrect/good practice/bad practice or just a matter of
personal preference?

[Lyle Fairfield]

"Allen Browne" <Al*********@Se eSig.Invalidwro te in
news:45******** *************** @per-qv1-newsreader-01.iinet.net.au :

It's correct syntax, so it boils down to style.

My presonal preference is to use the Call keyword, and include the
brackets. I find that's more readable and consistent across VBA
versions, and the same syntax works regardless of whether you are
calling a Function or Sub, e.g.:
Call Text1_BeforeUpd ate(Cancel)
Call MyFunctionWhere IDontCareAboutR eturnValue(Some Var)

Try

MyFunctionWhere IDontCareAboutR eturnValue SomeVar

I think you will find that it works as well.

--
lyle fairfield