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
- Junior Rangers
- How long does it take to become a good writer?
- Laurier in Chain e-mails on Immigration
- SQL Server 2005 file sizes and filegrowth
- Creating a SQL Server database by script
- Meet the Robinsons
- Query to return table rowcounts & identity values in SQL Server
- Cycling from Oshawa to Montreal – Day 4
- Winter biking
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