save but not save() -vba

[lezawang]

Hi
How come excel would accept the first code but not the second one. I thought save is a function and if you call a function then you should use this syntax

ObjectName.FunctionName() <<if the function takes no argument >>

Sub myfirst()
Workbooks(1).Save
End Sub
++++++++++++++++++++
Sub myfirst()
Workbooks(1).Save ()
End Sub

 

[MARK858]

Better question is why do you think it should accept the brackets? and no it is not a function.

 

[lezawang]

Thanks for your reply. I know you said it is not function but the Object browser is showing that Save has a green icon infront which mean it is function and when I click on it the Object browser says

Sub Save()
Member of Excel.Workbook

It is surprised me it says Sub not function but anyway still it has () as part of its syntax?

Thank you.

 

[MARK858]

https://docs.microsoft.com/en-us/office/vba/api/excel.workbook.save
https://docs.microsoft.com/en-us/office/vba/api/excel.workbook
https://docs.microsoft.com/en-us/office/vba/api/excel.workbook#methods

 

[MARK858]

I know you said it is not function but the Object browser is showing that Save has a green icon infront which mean it is function

Seeing as I am going out soon also see table 8.2 in the link below

https://books.google.co.uk/books?id...#v=onepage&q=vba object browser icons&f=false

 

[lezawang]

Thanks for your help. the first link https://docs.microsoft.com/en-us/office/vba/api/excel.workbook.save
says the Save is a method. Hence, any method of an object should be called like this

ObjectName.MethodName()

Am I right?

https://docs.microsoft.com/en-us/office/vba/api/excel.workbook.save
https://docs.microsoft.com/en-us/office/vba/api/excel.workbook
https://docs.microsoft.com/en-us/office/vba/api/excel.workbook#methods

 

[MARK858]

No

 

[lezawang]

Thanks, I think I understand it now. Let say we have an object called ABC which has 2 functions, one is called foo1() which takes no argument and the second one is called foo2(int x) which takes one argument of type int. to call these functions in vba code, i can use the following

sub whatever()
ABC.foo1
ABC.foo2(100)
end

The idea is this, if the function does not take an argument then you can called it using function name without () but if the function takes an argument then you need () and pass the argument between (). Am I right?

 

[MARK858]

Yes for a Function but as Microsoft have stated .Save is not a Function, it is a Method.

 

[lezawang]

Thank you very much for helping me to understand. But I thought Method = Function. Sometime people call it method and sometime call it function. It is the same thing or I have been under impression they are the same thing, or different way to name same thing!! I guess I am wrong.