Tag Archives: code

Excel VBA Copy Range, Paste as Table to Powerpoint 2010/2013

So, I’ve spent the last couple of weeks trying to get that one right. Piecing together all the hints from stackoverflow and the rest, I find┬áthat I have to use the ExecuteMso method available in PP2010 and later, and use … Continue reading

Posted in Uncategorized | Tagged , , , , | 22 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