Drawing in Excel

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.

Advertisements

About tgrignon

I came I saw I rented the DVD
This entry was posted in Miscellany and tagged , , , . Bookmark the permalink.

One Response to Drawing in Excel

  1. dougaj4 says:

    Thanks for the link and the comments.

    A useful resource, if you like printed documentation, is Excel 2007 VBA by Green, Bullen, Bovey and Alexander. It’s very “dry”, but it’s full of useful information; about 1/3 of its 1100 pages is a full listing of the Excel object model. Very like the printed documentation we used to get with software once.

    Doug

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s