Experiments, tutorials and ideas on developing business intelligence solutions
When we talk about performance in computing, almost unanimously the views suggest that C++ being the leader in performance oriented computing. Well our lovely excel is built on it, and so forth we also have a route to bring in some more C++ into excel world via UDF and enjoy the flavours of high performance Read More …
Many times I came across scenario when I wished the magic of .net would have been showered into VBA, by Microsoft. Phew but ne ways… So recently I thought if I could possibly use the dynamic VBA concept to replicate the property Get/Set in VBA by its name (only) dynamically at run time. And here Read More …
Recently, while compiling my previous blog list summary table I came across an interesting problem, how do I get a list of so many blog entries in a table (as illustrated in my previous post)?? Format: Post Title, Link UDF (user defined function) was at rescue for me; I just had to copy and paste Read More …
Welcome Welcome!!! Hello readers, it’s been a while since last I sent out a post on my blog. Recently many things were moving fast on my side, and I started finding it a bit of a pain to keep my previous blog intact due to fast pace of our technological improvements in browsers space and Read More …