SELECT AGENT,SALEAMT,COMMPERC,COMMAMT FROM INITFILE INTO CURSOR EXCEL_INITFILE
EXCEL_TITLE_NAME_1=LGS("Agent Commission Listing")
EXCEL_SUB_TITLE_1=LGS("Agent")
EXCEL_SUB_TITLE_2=LGS("Sales")
EXCEL_SUB_TITLE_3=LGS("Comm.%")
EXCEL_SUB_TITLE_4=LGS("Comm.Amt.")
EXCEL_COMMAND_AMOUNT(2,2)
EXCEL_COMMAND_DISTAX(3,3)
EXCEL_COMMAND_AMOUNT(4,4)
EXCEL_COMMAND_51=[OEX.CELLS(EXCEL_TNROW+2,2).VALUE=TSALEAMT]
EXCEL_COMMAND_52=[OEX.CELLS(EXCEL_TNROW+2,4).VALUE=TCOMMAMT]
EXCEL_COMMAND_71=[OEX.RANGE('A'+ALLTRIM(STR(EXCEL_TNROW+2))+':D'+ALLTRIM(STR(EXCEL_TNROW+2))).BORDERS(8).LINESTYLE = 1]
EXCEL_COMMAND_72=[OEX.RANGE('A'+ALLTRIM(STR(EXCEL_TNROW+2))+':D'+ALLTRIM(STR(EXCEL_TNROW+2))).BORDERS(8).WEIGHT = 3]
EXCEL_COMMAND_73=[OEX.RANGE('A'+ALLTRIM(STR(EXCEL_TNROW+2))+':D'+ALLTRIM(STR(EXCEL_TNROW+2))).BORDERS(9).LINESTYLE = 1]
EXCEL_COMMAND_74=[OEX.RANGE('A'+ALLTRIM(STR(EXCEL_TNROW+2))+':D'+ALLTRIM(STR(EXCEL_TNROW+2))).BORDERS(9).WEIGHT = 3]