Excel VBA extract multiple values for field

[Gravey]

I have some VB code that allows me to interrogate an LDAP database, but there are some "security group" group fields that I can't pull back.

The code is:

Please Login or Register  to view this content.

When I export the LDAP data to a text file, it comes out as:

dn: uid=NameU, ou=People, o=server.name
staffid: 1616
uid: NameU
accessright: 2002
accessright: 2004
accessright: 2013
accessright: 2014
group: 310
group: 176
group: 215
group: 407

And that is basically what I want to be able to retrieve from LDAP directly into Excel.

Any ideas?

[Gravey]

Cancel that. Found it.

http://www.dbforums.com/microsoft-ac...tents-vba.html