Author Archives: dougaj4

Salthouse

Posted on 26/03/2014 by dougaj4

To show a bit of Southern Hemisphere solidarity with Jeff Weir (who has been getting a bit of flack for having the temerity to discuss non-Excel matters on an Excel blog), I’m bringing forward my next Bach instalment. This post … Continue reading →

Posted in Bach | Tagged , | 1 Comment

Transfer of arrays to/from Python with Pyxll – Part 2; Speed

Posted on 22/03/2014 by dougaj4

Following the previous post, which looked at the way different data types worked when transferring data between Excel and Python, this post looks at ways t0 get the best performance. As a benchmark I have used a short routine that: … Continue reading →

Posted in Arrays, Excel, Link to Python, NumPy and SciPy, VBA | Tagged , , , , , , | 1 Comment

Transfer of arrays to/from Python with Pyxll – Part1; Data Types

Posted on 16/03/2014 by dougaj4

This post will look at options for transferring arrays between Excel and Python using Pyxll, including data types, and problems associated with transferring mixed data types.  In the following post I will look at the relative performance of the various … Continue reading →

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

More from the little unsaid

Posted on 09/03/2014 by dougaj4

First Real Steps (whilst floating down a London canal tunnel) On the making of his new album (and living in London) and crowd funding through Pledgemusic: http://www.pledgemusic.com/projects/thelittleunsaid

Posted in Bach | Tagged , , | Leave a comment

Problems with UCase and LCase in VBA

Posted on 08/03/2014 by dougaj4

A recent comment reported a problem with the use of the UCase and LCase (upper and lower case) functions in VBA.  The function was returning the error message “Compile error: Can’t find project or library”. I found the same problem … Continue reading →

Posted in Excel, Link to dll, VBA | Tagged , , , , , , | 6 Comments