workbooks.open - with or without ( )

[lezawang]

Hi
I understand that workbooks.open returns a workbook object. So it returns something and because of that, I thought it should be call using ( ) for example workbooks.open("abc.xlsx"), but the author of this link https://analysistabs.com/excel-vba/open-close-existing-workbook/
called workbooks.open function without using ( )
Any idea why? and why it works? Thank you

Sub Open_ExistingWorkbook()
    Workbooks.Open "C:\WorkbookName.xls"
    'OR
    'Workbooks.Open Filename:="C:\WorkbookName1.xls"
End Sub

 

[JLGWhiz]

If you use an = symbol

Set wb = Workbooks.Open(fileName)

You need the parentheses ()
but if you just

Workbooks.Open fileName

then you do not use the parentheses.

The reason is that the underlying application of VBA is written that way. Apparently, two different software engineers at two different times had different opinions of how it should be.

If you look further down in the ariticle you will see that the author did use the parentheses when using the = symbol.

 

[Michael M]

Just different ways of writing the code.....maybe you could have posted on their webpage and asked the very same question ??
I guess the same as adding a sheet can also be written differently

Sheets.Add(After:=Sheets(Sheets.Count))
activesheet.name="bla bla"

could also be

Sheets.Add.name="bla bla"

 

[lezawang]

Thanks once again for all your help. I tried the code below and I noticed excel accept "x=workbook.count()" and "x=workbook.count"
I thought since I am assigning the fuction to x then I must use ( ) but that is not the case. Thank you so much.

Sub xyz()
    Dim z As Integer
    Dim x As Integer
    x = Workbooks.Count()
    z = Workbooks.Count
    MsgBox z
    MsgBox x
End Sub