Category Archives: Productivity

Extend Excel: London 18 Oct

Charles Williams is organising  a conference in London on October 18th, 2018. I’ll be there! This is a rare chance to meet leading developers from all over the world and hear directly from MS on Excel Extensibility. Expect to be … Continue reading

Posted in Excel/VBA, ExcelDna, Open Source, Productivity, Research, Software Quality, Software Testing, Uncategorized | Tagged , | Leave a comment

VBA code for Microsoft Text Translator API

I have now updated the translator VBA source code to V3. https://docs.microsoft.com/en-us/azure/cognitive-services/translator/migrate-to-v3 V2 was deprecated on April 30, 2018 and will be discontinued on April 30, 2019. The Microsoft Translator Hub will be retired on April 30, 2019. View important migration … Continue reading

Posted in Excel/VBA, Open Source, Productivity | Tagged , | 15 Comments

VBScript to list installed OLEDB Providers

I found that the script I got by googling for that title failed on the line: CreateObject(“RegEdit.Server”) Error: ActiveX component can’t create object: ‘RegEdit.Server’ So here’s my own VBScript : ‘List of installed OLEDB providers on local computer Option Explicit … Continue reading

Posted in Productivity | Tagged , , , , , | 2 Comments

Excel 2013 Inquire Addin improved IQ

In my previous blog post I complained that the Excel 2013 INQUIRE addin showed every single formula in A1 style, which is useless for recognising blocks of identical formulas. So I’ve now done something about that – I am making available … Continue reading

Posted in Excel/VBA, Productivity, Risk | Tagged , , , | 6 Comments

String fuzzy matching in VBA and VB.Net

This describes how I speeded up a slow VBA string similarity function by first optimising the VBA and then migrating to VB.Net with Excel-Dna. If you’re a follower of Charles Williams’ FastExcel blog, none of this will be new to … Continue reading

Posted in Excel/VBA, ExcelDna, Productivity | Tagged , , , , , , , , , , | 5 Comments