Category Archives: VBA

Linking Excel to C

Posted on 02/09/2008 by dougaj4

One of the reasons often given for preferring programs like Matlab to Excel for scientific and engineering uses is the large body of specialist mathematical and scientific applications available to these programs.  In this and following posts I will describe how … Continue reading →

Posted in Excel, Link to dll, UDFs, VBA | Tagged , , , | 28 Comments

Solving simultaneous equations

Posted on 27/08/2008 by dougaj4

Solving a series of simultaneous equations is a task frequently required in engineering and scientific analysis.  Excel provides the tools to perform this task quickly and easily, but the procedure is not documented in the on-line help (so far as … Continue reading →

Posted in Arrays, Excel, Maths, UDFs, VBA | Tagged , , , , | 5 Comments

Intersections, interpolations, and rotations

Posted on 10/08/2008 by dougaj4

Amongst the many and varied functions provided by Excel (or as far as I know any other spreadsheet) there are none that provide a one step process for linear interpolation, finding the intersection points of lines, or conversion between polar … Continue reading →

Posted in Coordinate Geometry, Excel, UDFs, VBA | Tagged , , , , , , | 37 Comments

Drawing in Excel 5 – Shape List

Posted on 26/07/2008 by dougaj4

Previous Post For some reason best known to Microsoft, the Excel documentation does not include a graphic list of shapes with an example of each shape, and the text list they do provide is incomplete.  The file shapelist.zip rectifies that … Continue reading →

Posted in Drawing, Excel, VBA | Tagged , , , | 4 Comments

Drawing in Excel-4

Posted on 15/07/2008 by dougaj4

This post will look in a bit more detail at the methods presented in the previous post.  It would be a good idea to open the previous post on another tab, or download the example file and open the code … Continue reading →

Posted in Drawing, Excel, VBA | Tagged , , , | 3 Comments