Web Query with parameters (or LDAP)

**faun** · 02-21-2013, 12:14 PM

Good day,

Within our company, every employee has its own telephone number. The problem is however that this number can change. We have certain lists of our employees, each of every building. After a while, we get lists with outdated telephone numbers. Because it is too time-expensive to check every telephone number, we would like to get our excel-file to get the telephonenumbers from an external source that is always correct. The telephone numbers of our company are in a LDAP database, with public acces from this URL:

http://www.ugent.be/nl/telefoonboek/@@people?ugentid=XXXX with XXXX as a variable. XXXX is every employee's unique ID number.

I would ask every employees unique ID and I would have a webquery that gets the telephonenumbers from that website. However, I encounter following problems:

- If I have a building with more than 100 people, I need to make 100 webquery's. That's very time consuming.
- The number of webquery's needs to be exact the number of people, or I get a "returned no data" error.

So, here are my questions:

- Is there any way to change my current webquery's to VBA code to solve my problems?
- Or could I get direct acces to the LDAP database wich is public within excel??

These are the connection details:

Directory Server : ldaps.UGent.be
Base DN : dc=UGent,dc=be
Security : use SSL
Port Number : 636

PS: I included my excel file and the iqy file.