Monthly Archives: September 2013

Python for VBA users – 2

Posted on 29/09/2013 by dougaj4

This post will look in more detail at translating the VBA Quadratic function (described in Python for VBA users – 1) into a Python function, linked to Excel via PyXll.  For the purposes of this exercise I created a new Python … Continue reading →

Posted in Excel, Link to Python, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , | 11 Comments

Commenting a block of code in VBA

Posted on 26/09/2013 by dougaj4

One way is to manually place an apostrophe at the start of every line in the block. A much easier way (I just found out today) is: Go to View-Toolbars-Customise Select the Command tab Select the Edit Category on the … Continue reading →

Posted in Excel, VBA | Tagged , , | 9 Comments

Python for VBA users – 1

Posted on 24/09/2013 by dougaj4

Following my recent posts on some preliminary experimentation with linking Excel to Python, this will be the first of a more structured series, mainly as a reminder to myself of lessons learnt on the way, but also I hope of … Continue reading →

Posted in Excel, Link to Python, UDFs, VBA | Tagged , , , , , | 2 Comments

Sorting with Python

Posted on 19/09/2013 by dougaj4

A previous post provided a VBA Sort function that could be used as a User Defined Function (UDF) to provide a sorted list on the spreadsheet, or called from another VBA routine to sort an array. I have just written a … Continue reading →

Posted in Arrays, Excel, Link to Python, UDFs | Tagged , , , , , | 5 Comments

Python matrix functions in Excel, using Pyxll

Posted on 10/09/2013 by dougaj4

Following my previous Python post I have now successfully created a number of matrix arithmetic User Defined Functions (UDFs), using Python, SciPy and the PyXll add-in: The spreadsheet and associated Python modules may be downloaded from Matrixpyxll.zip See the previous post … Continue reading →

Posted in Excel | 2 Comments