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

[Bryan44]

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

 

[Jim Cone]

"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.
--
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

 

[Bryan44]

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