Tag Archives: code generation

VBA code generation on the spreadsheet

Posted on February 7, 2012 by dougaj4

A previous post looked at using VBA to generate more VBA code.  This post looks at automatic code generation on the spreadsheet, which may be transferred into the a VBA project using the techniques discussed in the earlier post, or simply … Continue reading →

Posted in Arrays, Excel, Finite Element Analysis, Newton, UDFs, VBA | Tagged , , , , , | Leave a comment

Code Generator

Posted on July 22, 2010 by dougaj4

One of the difficulties with Excel routines to solve differential equations, or do numerical integration, is that the equations to be solved must either be coded as VBA functions (which is time consuming), or solved using the evaluate function (which … Continue reading →

Posted in Excel, VBA | Tagged , , | 1 Comment