Run-Time Error (8000500d) - The directory property cannot be found

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bryan44 - 31 Jan 2008 02:35 GMT

I am pulling data from an LDAP server and run into this error when the
following code:

RecordValue = oObj.Get(Feild(LoopCounter))

tries to pull data for a data field that is blank. I'm just reading data
from this LDAP server. I'd like to be able to catch these errors when they
occur, fill the cell in my sheet with either a blank or even "No Entry" text.
However, On Error Resume Next doesn't prevent these type errors. Otherwise
all my code functions well other than when it hits a blank data field.
Anyone have ideas on how I can catch this error and just keep right on
trucking?

Any help would be greatly appreciated.

Bryan44

Reply to this Message

Jim Cone - 31 Jan 2008 03:06 GMT

"Feild" is misspelled; but that is probably just a typo in your message.
Don't expect much of a response on LDAP from an Excel programming newsgroup.

Signature

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"Bryan44"
wrote in message
I am pulling data from an LDAP server and run into this error when the
following code:
RecordValue = oObj.Get(Feild(LoopCounter))
tries to pull data for a data field that is blank. I'm just reading data
from this LDAP server. I'd like to be able to catch these errors when they
occur, fill the cell in my sheet with either a blank or even "No Entry" text.
However, On Error Resume Next doesn't prevent these type errors. Otherwise
all my code functions well other than when it hits a blank data field.
Anyone have ideas on how I can catch this error and just keep right on
trucking?
Any help would be greatly appreciated.
Bryan44

Reply to this Message

Bryan44 - 31 Jan 2008 12:42 GMT

Jim,

Thank you for the reply. Yes, it was late and I hand typed the code so I
mispelled field, sorry. I was hoping that someone else using ADODB might
know right away how to trap errors of this sort.

Bryan44

> "Feild" is misspelled; but that is probably just a typo in your message.
> Don't expect much of a response on LDAP from an Excel programming newsgroup.

Reply to this Message