Category Archives: Excel

Calling Add-in functions from VBA

Posted on 16/04/2011 by dougaj4

When an Excel add-in is active any User Defined Functions (UDFs) in the add-in are available to any other open worksheet.  It might be expected that the same would apply to VBA routines defined in other files, but if you … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , | 2 Comments

XLW

Posted on 13/04/2011 by dougaj4

Prompted by a thread at The Wilmott Forums that linked here, I was prompted to take a look at XLW- A Wrapper for the Excel API.  This is what they say about themselves: “XLW is an open source application that … Continue reading →

Posted in Excel, Link to dll | Tagged , , | Leave a comment

Alternative IP and Rotations

Posted on 11/04/2011 by dougaj4

In response to the 3D Intersections and PView Function posts Lori Miller has sent me two very elegant alternative ways of achieving similar results. The first is an on-spreadsheet solution to the intersection of two lines, using the LinEst function: Note … Continue reading →

Posted in Arrays, Charts, Charts, Coordinate Geometry, Excel | Tagged , , , | Leave a comment

Tanh-Sinh Quadrature V2.0

Posted on 04/04/2011 by dougaj4

I recently received an update of the Tanh-Sinh Quadrature spreadsheet from Graeme Dennes, which can be downloaded from:  Tanh-Sinh Quadrature (including, as usual, full open source code). – Link fixed 5th April 2011 Here is Graeme’s description of the updates: The … Continue reading →

Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , | 2 Comments

PView Function

Posted on 31/03/2011 by dougaj4

As promised in the previous post, here are further details of the PView User Defined Function (UDF), included in the IP2 spreadsheet, which can be downloaded (including full open source code) from IP2.ZIP. The PView UDF works by multiplying the 3D … Continue reading →

Posted in Arrays, Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, UDFs, VBA | Tagged , , , , , , | 3 Comments