Return type of function Workbooks.Add

[lastnn30]

Hi
In the object browser, workbooks.add function define as this

Function Add([Template]) As Workbook

The part I do not understand is "As Workbook"? What does that mean? Does that mean function add is an object of type Workbook? and that is why we can say this

Please Login or Register  to view this content.

Thank you.

[6StringJazzer]

It means that Add is a Function. A Function returns a value of some type, and in this case it returns a Workbook object. So you can treat a call to that function as if it were a Workbook object.

That is why your code works. I would not use the code that you showed because you create a new workbook which remains open, save it, and then do not have a handle to refer to it again in the code.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. I have updated it for you this time because you are a new member. --6StringJazzer