I wrote a VBA module for Excel over five years ago for clients. It has a User Interface in Excel which imports CSV data from one of our software packages and then creates scatter plots on a separate worksheet using the draw capability native to most of the Office packages.
Trouble was that my 1700 line macro did not migrate to Excel 2007 without mishap. I was trying to find references on Google today to figure out what went wrong. These are few and far between as Draw is badly documented in books, online help and even on the Microsoft Website.
I stumbled across this 7-item set of blog posts by Doug Jenkins while looking which helped a great deal. These are an excellent introduction with intriguing and practical demos to help anyone use Draw in Excel 2007. The Animation post and download was really cool.
With Doug’s tutorials I have cleared up half of my problems so far.
If wishes were horses
Golbing Time Dimension
- Using Excel to generate Inserts for SQL Server
- Veni, Vidi, Deus Vicit on this day in 1683
- Data Obfuscation through Random String replacement in SQL Server
- The Linguists
- SQL Server Performance and the IN clause
- SQL Server 2005 file sizes and filegrowth
- Best Christmas Albums
- Georgian Manor, hard sells and pyramid schemes
- First and Last Date of Month in T-SQL
Tag! You’re it!2008 age Apocalypse art Atheism bicycling Biology book Canadian Christmas climate change comedy conservation cycling database Disney documentary environment environmental awareness Excel fantasy film game graphic novel Guelph Guelph Festival of Moving Media Guelph International Film Festival haiku hiking history humour Jane Austen long distance love Microsoft Miss Celia Leblanc Montreal movie music mystery native Nature Neil Gaiman novel Old Growth Forest Oshawa performance philosophy Poem poetry Poetry Month quote recipe relationship review Robert J. Sawyer science science fiction short story silliness silly snow society Space opera speculative fiction Spring SQL SQL Server SQL Server 2005 Stephen King story The Education of Mike Moonblazer touring water writing