View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Run-Time Error (8000500d) - The directory property cannot be found


"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