LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Run-Time error '1004': No cells were found Regina[_2_] Excel Programming 13 November 28th 06 08:59 PM
Run time Error 380. Could not set the ControlSource property Ömer Ayzan Excel Programming 2 November 3rd 06 03:56 PM
Run-time error '1004': No cells were found Jamie Excel Programming 0 May 16th 05 11:01 PM
Run-time error '1004': No cells were found Jamie Excel Programming 0 May 16th 05 10:52 PM
Run-time Error '1004' Unable to get the findnext property... Tom Ogilvy Excel Programming 0 July 12th 04 04:27 PM


All times are GMT +1. The time now is 02:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"