This is a spreadsheet with a macro embedded that will read a line of commands in Excel, and put them into BricsCAD. It functions similarly to a script file.  It can replace the function of a dynamic block with a table, which is not available in BricsCAD.

This example version simply draws a rectangle and places the model# of a refrigeration condensing unit. It does this by first opening a new drawing, drawing the lines and text, and then it converts it to a block.   That block is then placed into the clipboard and the temporary drawing closed.  You can place the block by clicking anywhere in the original drawing.

PREPARING THE WINDOWS ENVIRONMENT, TO PERMIT THE PROGRAM TO RUN
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.

USING THE MACRO
To use the program, you will probably want BricsCAD open and a drawing open, where you want to insert the new block.  Open Excel, and this spreadsheet.
Select any cell on the row of the model you wish to create, and click the button that says “Copy Block to Clipboard”.

IMPORTANT INFORMATION FOR CREATING YOUR OWN VERSION.
     1.	The Data tab should contain the dimensional data that the script needs to fill in the values.  (The tab name does not matter)
     2.	The Script tab, must be named “Script” for the macro to recognize it. 
     3.	It does not care if a cell is a text or number format, because every cell will be converted to text when the script is formed.
     4.	The first row that can have a part and script is row #6.
     5.	The script must start on column A.
	 
Many thanks to the people on the BricsCAD user’s forum, and the BricsCAD support staff.  Without them, this program would not have come together.
-Joe Dunfee