J-Walk & Associates, Inc.

More On Office 2007 Colors

As a follow-up to yesterday's post on Excel 2007 colors, I recommend two excellent blog posts by Microsoft Word MVP Tony Jollans:

• Colours in Word 2007, Part I
• Colours in Word 2007, Part II

Tony gives an example of using VBA to create a shape in Word, Excel, and PowerPoint. Although the code is virtually identical, it produces different results in each of the programs.

Here's a statement, in Word, and the shape that it produces:

ActiveDocument _
  .Shapes.AddShape(msoShapeRectangle, 1, 1, 50, 50) _
  .Fill.ForeColor.ObjectThemeColor = msoThemeColorAccent2

And here's the same statement in Excel, and the shape that it produces:

ActiveSheet _
  .Shapes.AddShape(msoShapeRectangle, 1, 1, 50, 50) _
  .Fill.ForeColor.ObjectThemeColor = msoThemeColorAccent2

Both programs are using the default Office theme (unmodified).

Although Tony focuses mainly on Word, he covers a lot of ground and much of it applies to Excel. If you need to do any Office 2007 VBA programming related to colors, these posts are required reading (especially Part II).