Well i have used all those methods like "On Error Resume Next" and have tried to use the debugging methods like step through and breakpoints... The main problem of this error is that it doenst occur everytime. Its something to do with some sort of data that comes sometimes and then it errors out. I tried to filter the data but then again its accepting null values and also irregular ones and still working fine but this thing has only happened when the exe is running not from inside the V.B environment!! Since this Error 5 comes only i was hoping to take care of that error directly......