.... And this one is from an AUTODESK discussion group with code.

Note that a lot of this is to use VBA *from autocad* to push pull
information to different applications rather than to use the applications
VBA to pull from the DWG file.

And I'm sure that there is autocad vba code out there to go through a set of
DWG files.

One final thing... I have no idea  if there is a "macro recording" facility
in autocad vba but if there is that should help as well.