VBA inheritance and interfaces – can it be done?

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 with my client as a programmer (I am an engineer) he is bending my head a lot and really helping me see things from his perspective. Thanks man! So – now that I am using VBA … I could use some of this esteric ideas … or can I. This article is well written but I have to go home now.

http://stackoverflow.com/questions/19881863/how-to-use-comparison-methods-between-class-object-modules-in-vba-in-a-similar-m/19908375#19908375

Singleton classes in VBA

 

Share Button

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

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 table (which is why they won’t/don’t like it). But … how do we move forward AND satisfy IT? Well, an interim solution would be to use XML as the SQL Server data source and then build a url driven Service to extract data from Excel into this XML data source. So … links to get started you ask?

Can life get easier? What will the world be like in 10 years. This took me 5 minutes to see if we could do it. Now it is an interim solution because Excel is still the data source, but all we have to do now is replace Excel with an official app on the web in the near future – but to do this properly requires many many weeks of development, whereas a service – either works or doesn’t and only requires unit tests, not people to test is my simplistic view on this.

Share Button