• Get list of all users from Active Directory

    Home » Forums » AskWoody support » Productivity software by function » Visual Basic for Applications » Get list of all users from Active Directory

    Author
    Topic
    #466298

    ok so im wanting to get list of all users from Active Directory and display in Word 97 drop downlists.

    I found the following post which is similiar and helpful

    http://lounge.windowssecrets.com/index.php?showtopic=766573&view=&hl=”active%20directory”&fromsearch=1

    my question is:
    has anyone been successful in doing something similiar?

    im managed to query active directory and return data. should i be doing this each time the forms are loaded? seems abit excessive?
    or on Word startup or another trigger eg on login script should I do an active directory query, and store data in an excel file or txt file. – to then be used and called throughout the
    words session

    I suppose either method the data is going to be retrieved.
    Im just wanting the fastest method
    my other concern is if Word crashes, there maybe multiple sessions of winword.exe – which may effect code running during the AD data retrieval

    Im not sure about the data retrieval/storage process?

    many thanks

    diana

    Viewing 1 reply thread
    Author
    Replies
    • #1207552

      LDAP (AD) queries are pretty efficient if you just pull in the standard values – names etc – and limit the query to specific OUs, but they start to get out of hand and place big loads on the DCs if you request large multi criteria queries. I would test the query in a script to see how long it takes and if it’s only a few seconds then go with the simpler “query every time” option.

      cheers, Paul

    • #1207579

      thanks Paul

      diana

    Viewing 1 reply thread
    Reply To: Get list of all users from Active Directory

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: