It is - sort of - like the Word command Documents.Add.

However, as you have found out, you need an object to do so. An Excel application object. This can be early or late binding. If you do NOT need to worry about version issues, use early binding.

To use early binding you need to first set a Reference to the Excel libraries - this is done in the References menu item in the VBE.

Then you must declare your object variables.

Then you must SET your object variables.

There are lots and lots of examples to be found.