VBA In Excel - AD scripting

Hi guys,

Just a quick question, hope I'm in the correct area.

I'm doing VBA in excel, pulling data from the Active Directory to check and populate certain data.

All my querying was fine, except for this particular query, which has above 1500(probably about 3000-4000) members in it.

When i use:-

For Each Group In objComputer.GetEx("member"), it only manage to display till 1500 items, but the member list has much more items in it. It's of variant() type default. Is there any other alternate way to query this? or go around this method of getting the items? All other query(with less than records of 1500) was fine except for this..

Very much appreicate the help.!

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!