VBA In Excel - AD scripting

You Chun wrote:

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 members in it. When i use:- For Each Group In objComputer.GetEx("member"), it only manage to display till 1499 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 was fine except for this.. Very much appreicate the help.!

Hi,

The items are probably zero indexed, 0 to 1499 is 1500 items inclusive.

Count 0 to 5 on your fingers, you've counted 6 items, see what I mean.

Instead of your For Each loop, try 0 to 1499 instead in a FOR NEXT loop ( as a temporary measure ).

Additionally this forum is for VB.Net questions only, sorry.

Please see.>>

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=551512&SiteID=1

Try the MAIN VBA forum please.>>

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=74&SiteID=1

or this one.>>>>

http://www.programmersheaven.com/mb/vba/Board.aspx?S=B20000

Regards,

S_DS

Spidermans_DarkSide-MSP,VSIP at 2007-10-2 >