vba question: how to return a class from another class
I think this is a simple vba syntax question:
I have a class called 'funds' that contains a collection of strings, an add function and a sort function.
I'd like this sorting function to sort the strings in the current class object, then create a tmp funds class, add the names to the tmp class in sorted order, then return the tmp class.
I tried something like this:
dim tmpFunds as new Funds
dim raNames() as String
redim raNames ' to the size of this.count
assume the add syntax is correct. If I omit the name of the tmpFunds, it adds to this object correctly.
When I run this I get errors about the object not being declared on the set tmpFunds line.
What should the syntax be?
Is there an online reference for vba objects in etester?
I'll answer my own question: the line returning a class from a class.method was correct. the line directly above it was wrong (set tmpFunds=tmpFunds.Add(raNames) )
Once I corrected this to
set tmpFundIgnore = tmpFunds.add(raNames)
then I could execute
but only if the function was declared explicitly to return an object
[This message has been edited by j4moter (edited 12-03-2001).]