[AccessD] Help with creating an Excel Conditional Format from within Access

Mark Simms marksimms at verizon.net
Thu Feb 2 19:31:54 CST 2012


David - that's dangerous practice.
All you needed was a VBA Reference to the Excel 12 (or 14) Object Library.
Then you can reference any of the Excel constants or enumerations with
meaningful names.

I'm working on a complex workbook where the original developer never used
constants or enumerations.
Everything was a million references to hard-coded integers.....quite
abstract and very hard to understand and/or modify.

>
> I finally figured it out!
> I found a link with Excel Constants:
>




More information about the AccessD mailing list