It looks like you're new here. If you want to get involved, click one of these buttons!
It is working! The version I have attached is fairly simple, which would help those who are trying to understand how it works. The VBA code is thoroughly annotated.
There are probably some lines of code that might not be necessary. They are annotated as such.
I find that as my list of model# get long, the user has to scroll back up to the top to press the macro button. I am not sure how best to make this better. Perhaps there should be a VBA form that pops up when you press that button. And this form shows the list of model numbers. Ideally, that box may permit the user to filter the list or sort the list on various columns. But, I have struggled enough to get it to this point, that I want to leave it as it is for a while.
There is one important issue in regards to your Windows environment. Depending upon your security settings in Windows, you may have to set "Run as Administrator" in a few places. Otherwise Windows will prevent one program from controlling another. BricsCAD itself needs to be "run as admin". To do this, you have to find the BricsCAD.exe file, and right-click it and choose "Run this program as an administrator" on the Compatibility tab. After this, you must do the same for any shortcuts you use to start BricsCAD. Excel must have the same thing done to it.
Since VBA is not on all versions of BricsCAD, and not everyone has MS Office, ideally this concept will be redone using perhaps LISP to read an external file. However, since creating a complex script involves a lot of trial and error, it is very helpful if that external file is a spreadsheet that is read natively.
As I say in the included read-me, the program's existence was very much dependent upon the many on this forum, and the support staff at BricsCAD, who helped me when I got stuck... which was a lot.
[Edit, a few minutes after posting this, I realized that my simplification efforts had broken some parts of the script. So, the upload is now corrected]