Category Archives: VBA

Newton Excel Shakespeare

Posted on 27/02/2012 by dougaj4

Another excellent link from Al Vachris: Bruce McPherson’s Site This site is all about how to free your Excel data from your desktop and take advantage of web capabilities such as Docs, Maps, Earth , Gadgets, Visualizations and a whole … Continue reading →

Posted in Computing - general, Excel, Javascript, VBA | Tagged , , , , , | 2 Comments

Strand7 API GetNode functions

Posted on 19/02/2012 by dougaj4

As promised in this post, I have written and documented Excel User Defined Functions (UDFs) to interface with all the Strand7 API functions that return node attributes or results.  These 22 functions allow node attributes and results to be read directly … Continue reading →

Posted in Excel, Finite Element Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , | 5 Comments

VBA code generation on the spreadsheet

Posted on 07/02/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

Retrieving unique values from a range or array …

Posted on 31/01/2012 by dougaj4

… using the Scripting Dictionary object. in a previous post I looked at using the dictionary object to count connected elements in a finite element model.  This post looks at a more general (and simpler) usage to return unique values from … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , | 20 Comments

The Switch Function (VBA and UDF)

Posted on 27/01/2012 by dougaj4

Switch is a VBA function that operates in a similar way to the Select Case statement.  The function arguments are a series of pairs of values, the first of each pair being an expression that can be evaluated as TRUE … Continue reading →

Posted in Excel, Geotechnical Engineering, Newton, UDFs, VBA | Tagged , , , , | 9 Comments