I'm after a VBA script that I can run from within in Autocad and / or Intellicad. This VBA script will need to connect to an MS-Access database, open up a table and then within that table, go through each record and look at three fields: LName; LNumber and LAnnotation. When the script encounters a record > field in which LName begins with the prefix "CMT_" The script need to concantenate the text strings LNumber and LAnnotation from that record. LNumber is a number field and LAnnotaion is a text field. I've included a screenshot of the fields These concantenations need to then be written to a text file that I can use Lisp's read-line function on. I'm going to need the ability to change the Access database name as well as the table names but I'm assuming that's going to be fairly straightforward within VBA. My primary goal is to have the VBA script run on Autocad (say 2002 upward) but I also use an Intellicad platform so I'd like a quote on doing either AutoCad by itself or AutoCad and Intellicad 6.4
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):
a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
Other Files: See Attachment
AutoCad 2002 + Progecad 2008+ using Intellicad 6.4 Windows XP and Vista