November 2014 - ELB Solutions.com Inc.

VBA inheritance and interfaces – can it be done?

By Etienne Bley November 28, 2014February 3, 2022

First, my head hurts at then end of this so this post will be short until I can back to it and digest this stuff. Can VBA implement an interface like c#, cocoa or java? I have been using this stuff without really “getting it”. Now that we have a very smart individual who started […]

Excel to XML to avoid direct OPENROWSOURCE SQL data connection to Excel

By Etienne Bley November 18, 2014February 3, 2022

The company I am currently solving issues for will not accept Excel as a table data source. This I know, so therefore a really really great report cannot go on the live system. So I have been beating my head on how to get around the politics – good politics because Excel is a breakable […]