Feed on
Posts
Comments

Archive for the ‘VBA’ Category

Spending time on Excel-SQLite, C, VBA Callbacks & Twitter

Posted in BI, ETL, Palo, SQLite, VBA, Web2.0, excel, xLite, tagged , on November 20, 2008 | No Comments »

Haven’t posted here in a while as my spare time has been soaked up programing, well actually refactoring would be more exact.  My xLite “SQLite empowered Excel” codebase has grown over the years and required a serious makeover to get rid of stuff I no longer use and to generally make it more robust.  I [...]

Read Full Post »

Python to replace VB6 …

Posted in ETL, Python, VBA, excel, tagged , , on May 5, 2008 | 2 Comments »

… well at least for me. As I discussed previously I’ve been seriously investigating using Python as my primary datasmithing scripting language, in effect a new VBA. I also currently use VBA’s compiled cousin, VB6, for certain tasks such as building Excel RTD servers. The problem with VB6 is it depends on [...]

Read Full Post »

xlAWS - 100,000 downloads?

Posted in AmazonAWS, Proto, S3, SQLite, SimpleDB, VBA, programming, xLite, xlAWS, tagged , on April 2, 2008 | 2 Comments »

Not sure, but this morning I received my monthly AWS bill, and it was double its usual amount! When I investigated the extra cost it was due to 133GBs of downloads from my www2.gobansaor.com bucket. This is the S3 bucket in which I store the xlAWS zip file, xlAWS being a “library-of-sorts” of [...]

Read Full Post »

xlAWS - Excel VBA Code for accessing Amazon’s S3 and SimpleDB

Posted in AmazonAWS, S3, SimpleDB, VBA, excel, programming, tagged , , on February 22, 2008 | 4 Comments »

I’ve been using Amazon’s S3 service from within Excel for sometime now and as there are no libraries or examples for calling AWS services from VBA (or VB6) I had to roll my own. As with most things Excel, getting the job done always triumphs over elegance and industrial strength implementations, in other words [...]

Read Full Post »

Dublin Bus and PALO ETL - the connection!

Posted in AmazonAWS, BI, ETL, Palo, S3, SQLite, SimpleDB, Talend, VBA, excel, kettle, olap, tagged , , , , on January 26, 2008 | 5 Comments »

Dublin buses, as is the norm with most road-based public transport systems in our increasingly car-choked cities, tend to operate on the basis of “no sign of a bus for ages, then two or three arrive at the same time”. Palo MOLAP ETL options appear to be following the same pattern; we’ve been waiting for [...]

Read Full Post »

JavaScript as an Excel scripting language via ExcelDNA

Posted in JavaScript, VBA, excel, tagged , , , , , , on October 4, 2007 | 2 Comments »

Developing .NET DLLs that are to be used within an Excel VBA add-in is relatively easy to do. But the overhead of the COM managed interfaces can be a serious performance bottleneck if the .NET managed functions are called from within a tight loop. The alternative is to create a C++ XLL and [...]

Read Full Post »

Proto - desktop BI tool.

Posted in ETL, Proto, RSSBus, VBA, news, xLite on September 9, 2007 | 1 Comment »

I see that Proto have repositioned their excellent VBA scripted mash-up product as a “desktop business intelligence system”. This is to be welcomed as the first time I used it I described it as a “mash-up tool for adults” and although it has the ability to play hard ball with the other Web2.0 mash-up [...]

Read Full Post »

Google Spreadsheets - ETL tool

Posted in BI, ETL, GoogleApps, RSSBus, Ruby, SQLite, Talend, VBA, Web2.0, excel, kettle, tagged on September 6, 2007 | 1 Comment »

Although I’m a total Excel fanboy, I most admit I rarely use it any longer for personal stuff such as home budgets, tax calculations, what-ifs, to-do lists etc.; I now tend to use Google Spreadsheets. Likewise, personal notes, drafts and useful bits of code are stored using Google Docs rather than MS Word. [...]

Read Full Post »

In Memory OLAP

Posted in BI, ETL, Palo, SQLite, VBA, data, excel, olap, xLite on September 5, 2007 | 4 Comments »

The consolidation within the BI market continues, this time with the purchase of Applix by Cognos. As Timo Elliott points out, the interesting bit is the Applix TM1 memory-centric OLAP product. For the vast majority of OLAP users (i.e. the millions of Excel Pivot table jockeys) in-memory OLAP is nothing new, but traditionally [...]

Read Full Post »

SQLite Star Query Part II

Posted in BI, ETL, Palo, SQLite, VBA, excel, olap, xLite on August 31, 2007 | No Comments »

In my previous post I looked at simulating a bitmap-join in SQLite using a sub-query and the INTERSECT command. The problem is of course, this is a simulation, SQLite lacks bitmap indices and although the sub-query will read only the fact table’s index B-trees (avoiding accessing the fact table proper) and should be [...]

Read Full Post »

Like Excel macros? You’ll love this..

Posted in ETL, GoogleApps, Ruby, VBA, excel on July 17, 2007 | 5 Comments »

One of the most used (and abused) features of Excel is its macro recording facility. How many mundane and repetitive actions have been automated using this feature? How many people found the courage to program in VBA by using the recorder as their training-wheels? Well now iMacros (from German company iOpus [...]

Read Full Post »

dhSQLite - now with FTS2 and VB UDFs

Posted in ETL, SQLite, VBA, data on June 29, 2007 | 2 Comments »

Datenhaus has just released a new version of dhSQLite based on the latest SQLite 2.4.0 3.4.0 engine which according to www.sqlite.org…
…fixes two separate bugs either of which can lead to database corruption. Upgrading is strongly recommended…
This version of dhSQLite has the FTS2 module compiled in, which adds full-text indexing to SQLite. Version 1.2 also [...]

Read Full Post »

dhSQLite - New SQLite COM Wrapper

Posted in SQLite, VBA, excel on June 1, 2007 | 4 Comments »

I’ve just come across a new COM wrapper for SQLite from German company Datenhaus (like the name, maybe I should call myself Datenschmidt?). I’ve started to use the COM free PSSQLITE.DLL in my Excel VBA projects but I may consider using the Datenhaus dhSQLite library in certain situations as it includes a database encryption [...]

Read Full Post »

JavaFX - a GUI DSL

Posted in ETL, Java, JavaFX, JavaScript, Ruby, SQLite, Talend, VBA, excel, programming on May 19, 2007 | 4 Comments »

Having mastered JavaScript (OK master is too strong a word - having become comfortable with both its syntax and usage patterns) my next port of call is JavaFX the recently announced Flash/Silverlight competitor. What led me to JavaFX Script was not its role in this Flash/AJAX alternative platform (which unless  Sun improves [...]

Read Full Post »

VBx - the future VBA?

Posted in Ruby, VBA, excel, tagged on May 2, 2007 | No Comments »

With the future of VBA being a concern for many Office professionals, some of the  MIX07 announcements around dynamic language support in Silverlight may shed some light on a potential replacement for the VBA, VBx.
There’s life in the old dog yet, it may yet get to share the limelight with its cooler cousins Ruby and [...]

Read Full Post »