David McAfee
davidmcafee at gmail.com
Thu Feb 2 21:37:13 CST 2012
The only thing with that is that our users can have office xp, 2003, 2007 , 2010 or 2010 SP1. The report in question is ran from two different users. One running A2003, the other uses A2010 SP1. If you can recommend a better way of doing it, I'm all ears. Thanks, David Sent from my Droid phone. On Feb 2, 2012 5:33 PM, "Mark Simms" <marksimms at verizon.net> wrote: > 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: > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >