Category Archives: Computing – general

FeedSpot

Posted on 24/05/2026 by dougaj4

Feedspot is a blog database with a huge list of different categories, each with listings of the best blogs, including: 60 Best Excel Blogs to Follow in 2026 with a wide range of blogs, including: For a complete list of … Continue reading →

Posted in Computing - general, Excel | Tagged , , | Leave a comment

The Ultimate Python Guide for VBA Developers

Posted on 15/04/2026 by dougaj4

I recently discovered “The Ultimate Python Guide for VBA Developers” which is a free book available from the pyxll site at https://www.pyxll.com/learn-python.html. The pyxll site says: This book has been written specifically for VBA and Excel users like you. Fast … Continue reading →

Posted in Computing - general, Excel, Link to Python, Python Pandas, PyXLL, UDFs, VBA | Tagged , , | Leave a comment

Importing text files with Python and pyxll

Posted on 02/08/2025 by dougaj4

VBA code to import text files to Excel was presented at Importing text files with VBA – 2 and following posts. We now look at Python code for a user defined function (UDF) for the same task. The code requires Python … Continue reading →

Posted in Computing - general, Excel, Link to Python, PyXLL, UDFs | Tagged , , , , , | Leave a comment

Python Match Case Statement

Posted on 06/06/2025 by dougaj4

The Python match case statement was introduced in Python 3.10. It provides similar functionality to the VBA Select Case statement, but also has additional features. For detailed background with examples see: geekforgeeks – Python Match Case Statement The example below … Continue reading →

Posted in Computing - general, Excel, Link to Python, PyXLL, UDFs | Tagged , , , | Leave a comment

Pandigital sums and Python permutations and combinations

Posted on 13/04/2025 by dougaj4

The New Scientist brain twister from last weeks edition has several problems involving pandigital sums, which are additions that use each of the digits from 0 to 9 exactly once, and with no number within the sum that starts with … Continue reading →

Posted in Arrays, Computing - general, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs, VBA | Tagged , , , , , , , | Leave a comment