Yes. My mistake.

Looking closer at the code, m.bn is part of the table name but the select statement is still using the same alias. OpenTable must be using a table with an alias of AppExp. I would check the open function to make sure the correct table is really being opened.

>>I don't see a where on your query. Without the where you will always get the first row.
>>
>
>Don't you mean you will always get all rows?
>
>
>>>>>Alright, I just tried it and it's still only giving me the first file I type in, ignoring the comma and other file I type after it... This is what the code looks like now:
>>>>>
>>>>>

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
>>>
>>>
>>>I just tried that too and get the same result... I don't get it.