Fix Runtime Error in VBA

Posted on 24 June 2009

To fix runtime errors is VBA, use the following three statements - On Error, Resume and Debug. The first one traps a runtime VBA error when it occurs, the second one tells the application the point from which to resume code execution when the error has been caught (if you decide to catch the error) and the third one informs the user where (and which) runtime error took place. A runtime Error in VBA can occur for a plethora of reasons. ... Continue Reading

Comments (2)

Read Write to File, Excel Workbook, Access using Javascript & SQL

Posted on 22 June 2009

Read Write to File, Excel Workbook, Access using Javascript and SQL Javascript when used with ADO* and SQL can read write from data sources such as a file, Excel or an Access database. (* ADO = ActiveX Data Object). Since this technique relies on the use of ADO, a bit about ADO before we begin to help you understand how this works. According to wiki, Microsoft's ActiveX Data Objects (ADO) is a set of Component Object Model (COM) objects for accessing ... Continue Reading

Comments (6)

Funny Graphics

Posted on 21 June 2009

A couple of funny graphics to get you over the weekend blues :-) Viagra Sales (Courtesy: funnytimes.com) The right spot Finding the right man can be quite a challenge. (Courtesy: hottestsnaps.blogspot.com) Length of shorts (Courtesy: iamtheweather.com) The world of 100 If the world were to consist of only 100 people: ... Continue Reading

Comments (3)

Bump Chart

Posted on 18 June 2009

Bump charts got their name from “bumps race’”, a term used to refer to a boat race where each boat tries to “bump” the one in front and move up the chart. Bump charts have become quite common of late and are typically used to represent changes in the position of a given number of competing entities over a fixed time duration. Bump charts have been featured quite prominently on Kiaser ... Continue Reading

Comments (1)

Stock Chart with Scroll and Zoom

Posted on 17 June 2009

Stock charts come in various shapes. There are candlestick stock charts, line and bar stock charts, “Kagi” stock charts, moving average stock charts and everything in between. For a financial service provider how to present financial information pertaining to a specific stock can a critical question. On one hand, if you give too many options, you loose out on user comfort and increase API complexity. On the other, give too few options and you end up losing more demanding customers. ... Continue Reading

Comments (4)

Chart Table - When a Beautiful Chart meets a Handsome Table

Posted on 16 June 2009

Chart table - as the name suggests - is a beautiful fusion of a chart and a table giving rise to a visually appealing yet information rich presentation of data. Not that the concept itself is anything new - experts have openly and vociferously championed the cause of the chart table, its various facets have been discussed at length in numerous forums and the latest versions of excel come equipped with tools that further aid their creation (namely sparklines). However ... Continue Reading

Comments (1)