Category Archives: Productivity

VBA code for Microsoft Text Translator API

Microsoft are retiring the Translation API in the Datamarket on April 30, 2017. You need to sign up to the Azure Portal and use the Text Translator API in Cognitive Services. https://translatorbusiness.uservoice.com/knowledgebase/articles/1078534-microsoft-translator-on-azure Action Required before April 30, 2017: Microsoft Translator … Continue reading

Posted in Excel/VBA, Open Source, Productivity | Tagged , | 1 Comment

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