Tag Archives: Performance

VBA Performance Profiler : timing procedure execution

Posted on Jul 6, 2021 by Patrick O'Beirne, Excel/VBA developer

This is an update and replacement for the post on 9th March 2017 titled ‘Free add in to profile VBA speed and coverage’. Updated 8-Jul-2021 with an example profile report. Download XLTEST_VBA_Profiler.xlam. (Updated 22-Jul-2021: Tracing P_.O also sends to OutputDebugString … Continue reading →

Posted in Uncategorized | Tagged Performance, timing, VBA | 3 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 code, efficiency, fast Excel, fast VBA, fuzzy matching, optimisation, Performance, similarity, speed, String comparison, VB.Net | 5 Comments

	Patrick O'Beirne, Ex… on VBA Code Tracer / Profile…
	Dennis M Wallentin on ChatGPT 3.5 Excel script
	iqualitylife on VBA Code Tracer / Profile…
	Patrick O'Beirne, Ex… on Dictionary VBA Class upda…
	ayhan on Dictionary VBA Class upda…

Tag Archives: Performance

VBA Performance Profiler : timing procedure execution

String fuzzy matching in VBA and VB.Net

Recent Posts

Recent Comments

Archives

Categories

Meta