Category Archives: Productivity

Extend Excel: London 18 Oct

Posted on Jul 23, 2018 by Patrick O'Beirne, Excel/VBA developer

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

Posted on Jan 20, 2017 by Patrick O'Beirne, Excel/VBA developer

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 . The Microsoft Translator Hub was to be retired on April 30, 2019. View important migration information and dates. On Apr 30 … Continue reading →

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

VBScript to list installed OLEDB Providers

Posted on Jul 11, 2014 by Patrick O'Beirne, Excel/VBA developer

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 , , , , , | 4 Comments

Excel 2013 Inquire Addin improved IQ

Posted on Mar 6, 2013 by Patrick O'Beirne, Excel/VBA developer

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

Posted on Jul 27, 2012 by Patrick O'Beirne, Excel/VBA developer

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