When and when not to use "Parentheses"

[Akhila]

Hi,

Using the following option I was successfully exported sheet to C: drive
datatable.Exportsheet "C://sheet1",1

but when I used parentheses similar to below
datatable.Exportsheet ("C://sheet1",1)

QTP throwing syntax error saying "Cannot use parentheses when calling a Sub"

As I don't have much programming knowledge I always get confused with when and when not to use parentheses...
Can any one give tips on how to know about this?
and also what does it mean by the error I mentioned above.

Thanks,
Akhila

[Ankur]

sub refers to subroutine. Always remember these two rules when calling a subroutine:

1. When calling a subroutine without the Call statement, do not use parentheses.
   
2. If you want to use parentheses always use Call statement.
   

Ex: Call datatable.Exportsheet ("C://sheet1",1)

[Akhila]

Thanks Ankur!

One more doubt...

The statement below is not throwing any error even with parentheses, here am not using any Call statement.
Can I know the logic behind it?

DataTable.Export ("C:\flights.xls")

Thanks,
Akhila

[rajendra]

Thanks Ankur,

I am facing same issue as I m not getting any error message

EXataTable.Export ("C:\flights.xls")
I did not use "CALL"
Thanks,
Rajendra

[Ankur]

@Akhila, rajendra and others: Here is the answer to your question on When and when not to use parenthesis in VBScript?