How to create collection in office 2010 macro, VB 7.

I'm following the MSDN but I still get errors. Can anyone show me a line that creates a collection then adds an item to it, with name and number?

That would be great help.

I'm only writing: Dim sampleVisualBasicColl As New Microsoft.VisualBasic.Collection()

Error i get is: Compile Error - Expected End of Statement

If I remove the brackets and write it like this, it works: Dim sampleVisualBasicColl As New Microsoft.VisualBasic.Collection

also the Add function is not recognized.

Any reference out there for my problem? something I could take a look at?


Thanks.