NumberRecords = GETWORDCOUNT(m.bnin) > FOR i = 1 TO NumberRecords > m.bn = PADL(GetWordNum(m.bnin, i, ","),7,"0") > > *Opens the DBF file in the "key" folder, appends "A" and adds the user input as batch number > OpenTable(goWCServer.oConfig.oTask.cBTSPath+[key\A]+m.bn,[AppExp]) > > *Select columns from table above, name them for Excel headers > SELECT bn as [BatchNum],; > pk as [RecNo],; > "" as [Approved],; > shdt as [ShipDate],; > canm as [Carrier],; > prno as [Pro],; > blno as [BOL],; > shnm as [Shipper],; > ozp as [OZip],; > conm as [Consignee],; > dzp as [DZip],; > wtttl as [Weight],; > "" as [ReWeigh],; > "" as [Notes],; > accd1 as [Acc1],; > acamt1 as [Amt1],; > accd2 as [Acc2],; > acamt2 as [Amt2],; > accd3 as [Acc3],; > acamt3 as [Amt3]; > FROM AppExp; > ENDFOR > >*Copy data from cursor to Excel file >COPY TO ("C:\test\"+[bn]+m.bn+[T2.xls])you've got the endfor in the wrong place, it should be after the copy to