1. Try to assign all objects to object variables ('set' instruction)
2. If you have conditional jumps somewhere in the code, check if they refer to code blocks with the structure 'With ... End With' (access to the 'With ... End With' block before initiating it)
3. Are you sure you have correctly set all the required references 'Tools\References\=>?' (calling the wrong dlls ?)
4. Do you use "connection shortcuts" (':') in the code for subsequent commands (?) - maybe in some place of the code it was interpreted as the label name for the 'GoTo' jump ?
5. Maybe in sensitive points of your code you should additionally use the 'Err.Clear' method ?
6. Maybe you declared some variables without a specific type and there was a type conflict with the variables ?
7. Maybe somewhere in the code there is an assignment to the array without a specific dimension ?
It's hard to say without the sample code ... : (
Bookmarks