Hello,

I've been trying to do a for/each loop to iterate through a
collection.
I did the tricks mentioned in different posts (e.g export class-open
with notepad and add the necessary atributes adn the enum property and
then re-import to excel).
Does this works with office 97 or it works only for office 2000 and
above?
I'm using excel 97 but i can't make it to work.
If anybody knows how to do it and can give me some advise on that is
very welcomed.

Thanks,
stelio

Iterating through a collection doesn't have anything to do with the other
things you describe.

http://j-walk.com/ss/excel/tips/tip47.htm
Filling a ListBox With Unique Items

at John Walkenbach's site has code that iterates through a collection which
you could use as an example.

Enum was added in xl2000, but isn't required to iterate a collection.

the information I have see for adding attributes to a module usually has to
do with creating a default value for a class - but in any event, again, they
were not supported in xl97.

--
Regards,
Tom Ogilvy

"Stelio" wrote in message
om...
Hello,

I've been trying to do a for/each loop to iterate through a
collection.
I did the tricks mentioned in different posts (e.g export class-open
with notepad and add the necessary atributes adn the enum property and
then re-import to excel).
Does this works with office 97 or it works only for office 2000 and
above?
I'm using excel 97 but i can't make it to work.
If anybody knows how to do it and can give me some advise on that is
very welcomed.

Thanks,
stelio