Archive for the ‘Quick Tips’ Category

Quick Tip – Organize Your Custom 2DAs

November 28, 2009 2 comments

Occasionally, there are little tidbits that I run into that really aren’t extensive enough to justify a full tutorial, but the information is still useful. So I thought i’d occasionally post these little “Quick Tips”.

Some AddIns, and definitely larger campaigns, require the creation of multiple custom 2DA files. When you start having to deal with all these worksheets, it can get a little hectic, but here is a nice tip to keep things organized. When you compile your XLS files, the ExcelProcessor doesn’t care what the filename is, or even what worksheets are in what files. It simply compiles one GDA per Worksheet. Use this to your advantage by placing all the worksheets you need to edit into a single XLS file, and naming each worksheet appropriately.

Categories: Quick Tips