Accessing LDAP server from VBA and Office?

[Robert Staflin]

Does anyone have any experience or ideas about the possibility of
accessing an LDAP server through VBA in Office (preferable v. X)? I've
come across only one suggestion on how to connect to one in another
group:

Set objRoot = GetObject("LDAP://www.server.com")
Set myComputer = GetObject(" LDAP://" &
objRoot.Get("DefaultNamingContext"))

...but when I try it in Word 2001 or v. X I get a "Run-time error
'432': File name or class name not found during Automation operation".
The server exists, but I have my doubts whether VBA (which is version
5 in Office?) can do it.

Any comments would be welcome!

[Jim Gordon]

Hi

According to the VB object browser in Excel 2001 (I didn't check the Excel X
object browser but it is likely to be the same) the GetObject Method returns
Active X objects. Active-X is not support on the Mac.

On the other hand, the help file explains how to use this method with
Macintosh file paths, which is contradictory.

Have you checked AppleScript to see whether this functionality is available?
If you can get AppleScript (or UNIX for that matter) to grab the information
you need from the LDAP server, you can pass that information to Office
application VBA using variables.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

----------
In article <b76de68d.03050...@posting.google.com>,