How to create collection object

[aymanzone]

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.

[JosephP]

you are reading a vb.net page not a vba page. it should be

Please Login or Register  to view this content.

[aymanzone]

Thanks it worked. I tried googling "VB7 and Excel 2010" but kept finding other vb code, like .NET and some other one.

Now I just need to find a website for creating for loop for this collection, other methods and etc.



Thankee

Edit: Can anyone say how to mark post as Solved? .. still looking