Mike Alexander of DataPig Technologies has put together a video about using enumerations when you’re automating Excel from another application. Take a look.
You can download Excel_Enumerations.txt, which should take the drudgery our of setting those up yourself.
Speaking of Excel automation, Mike and I are putting on the Excel and Access Integration Workshop. (Subtle segue I know.)
This 2-day workshop is designed to give you a comprehensive review of the wide range of integration techniques that can be performed using Excel and Access. Through step-by-step instruction, you will explore the benefits of integrating Excel and Access, the differences and similarities between Excel and Access, and some of the common pitfalls of moving and analyzing data across applications.
It’s May 18-19, 2009 in Dallas. Definitely Excel and Access integration is one of my favorite topics, so I’m excited to be a part of it. Register here, if you’d like to come.