Many times you will need to export assortment information to excel, but you will not know in advance how many assortment items the user will have filled. In order to export a variable number of pieces of information do the following. We will use the Assortment UPCs for this example.

There are 3 scripting sections that you need to work with:

The “Globals” area is where you set up any global variables or functions you will need. Here we will declare a stringlist to hold all valid UPCs which will be used in the OnBeforeData and OnAfterData scripts.

dim slUPCs