Workbook.add

[lezawang]

Hi

Why the code below is acceptable?

Workbooks.Add.SaveAs Filename:="c:\testing.xlsx"

The part I do not understand, is that Add is a method so why excel accept

Add.SaveAs?

The above code, means Add is an object. So I checked Add and it is method that return Workbook as a type. A function return an object? That is confusing? any help how to understand that line of code? Thank you very much

 

[mikerickson]

The .Add function of the workbooks object returns a workbook object (the new workbook)

Workbooks.Add.SaveAs applies the .SaveAs method to that newly created workbook.

The code in the OP is the same as this

Dim wb as Workbook

Set  wb = Workbooks.Add

wb.SaveAs Filename:="c:\testing.xlsx"

 

[lezawang]

Thank you very much.