View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bryan44 Bryan44 is offline
external usenet poster
 
Posts: 12
Default Run-Time Error (8000500d) - The directory property cannot be found

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