How to write a macro in Excel

Posted on 29 July 2009

How to write a macro in Excel? Here are a few quick tips: Excel Macro - How to Record Excel Macro - How to Edit Excel Macro - Improving speed of code Excel Macro - Examples Recording a macro in Excel How to record a macro in Excel 2007 and Excel 2010 In Excel 2007 (and Excel 2010), the "Record Marco" menu option is under the "View" ribbon. Click on the "Macros" button towards at ... Continue Reading

Comments     

Make Mouse Scroll Wheel Work in VBA Editor (IDE)

Posted on 14 July 2009

This ranks right at the top of annoyances when it comes to working with the VBA IDE - the mouse scroll wheel simply does not work. So if you have more lines of code than can fit into a single screen in the VBA IDE, you end up having to drag the scroll bar to up/down to navigate. Jimmy Peña recently posted this very useful VBA tip on his informative blog that provides the solution to this issue. ... Continue Reading

Comments (10)

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 (8)

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 (5)

Sudoku Solver Code in Excel with Brute Force - Solver Code, Logic and Program

Posted on 11 May 2009

This Sudoku solver in Excel will help you solve a sudoku puzzle with brute force. This Sudoku solver, has been written in VBA and incorporates a brute force algorithm which helps its solve some of the toughest sudoku puzzles using nothing more than an excel spreadsheet. You can download the Sudoku Solver in Excel with Code, Logic and Algorithm here. In this article we will talk about how to develop a Sudoku solver using code in Excel, discover the tips ... Continue Reading

Comments (2)

Stress Test Results - A Classic Visualization Challange

Posted on 08 May 2009

The results of the "Stress Test - Housing Crisis of Shame" are out. I just saw NY Times publish the stress test figures this morning. The first thing that came to my mind when I saw the results was, well.......not that they require another $75 billion, that's pretty well known to most of us by now, was ....gosh.....what an opportunity wasted. Here was a important and relevant piece of data that could have really been presented better using ... Continue Reading

Comments