Category Archives: Excel

Installing Python, Scipy and Pyxll

Posted on 09/09/2013 by dougaj4

I have recently been experimenting with Pyxll, which after a few initial hiccoughs is proving to be an easy and efficient way to connect Excel to Python based scientific and maths applications, such as linear algebra routines and ODE solvers.  … Continue reading →

Posted in Excel, Link to dll, Link to Python | Tagged , , , , | 15 Comments

Arrays vs Collections vs Dictionary Objects (and Dictionary help)

Posted on 29/08/2013 by dougaj4

A recent comment by Lori Miller at Daily Dose of Excel suggested that (for the particular application being discussed) the VBA Collection object was quicker than using scripting dictionaries.  Since I hardly ever use collections (other than the built-in ones), and … Continue reading →

Posted in Arrays, Excel, VBA | Tagged , , , , | 7 Comments

Running VBA routines from a new workbook

Posted on 21/08/2013 by dougaj4

I have had a couple of queries recently which seem to be resulting from trying to run User Defined Functions (UDFs) from a new workbook, so this post will look at the options for using the VBA routines provided here (or … Continue reading →

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

Chain mail …

Posted on 11/08/2013 by dougaj4

… or a collection of inter-connected links (all e-mailed by Alfred Vachris, and all worth a look): 3D scatter plot for MS Excel – free spreadsheet with proper 3D scatter plot function. Excel Liberation This is not another Excel tips … Continue reading →

Posted in Excel | Leave a comment

Select and sum data using the scripting dictionary

Posted on 10/08/2013 by dougaj4

Another User Defined Function (UDF) prompted by a query at Eng-Tips. The question concerned a set of data consisting of 13 columns, which was to be divided into two sets, based on the contents of Column 4, then the contents … Continue reading →

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