Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unexplained "Bad Record Length" error / bug?
As an experienced VB programmer, I understand the normal causes of the
Bad Record Length error. I am stumped on this though and believe it to be some kind of bug in VBA... I have several user-defined data types which I use to Put/Get data to and from random-access files. Occasionally I get the "Bad Record Length" run-time error. There is no apparent reason for this error occuring, it is intermittent, and can be resolved by the following process: - comment-out an element within the data type - attempt to run a procedure that includes a reference to this element (this obviously causes a compile-time error "Method or data member not found") - end code execution - reinstate declaration of the element This process, in effect, forces VBA to recompile / rebuild the data type, and everything runs fine again. Anyone have an explanation? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Error "Unable to record" | Excel Worksheet Functions | |||
"Turn "record macro" display on. | Excel Discussion (Misc queries) | |||
What is Error "Method "Paste" of object "_Worksheet" failed? | Excel Programming | |||
"Unable to Record" error | Excel Programming | |||
Getting "compile error" "method or data member not found" on reinstall | Excel Programming |