Transfering table in different excel files(not worksheets)

[gamaz]

Hi,
This is a prototype table in access that I want to export to excel.

salesid businesschannel custid amt
001 A XXX 2000
001 A YYY 3000

002 A TTT 5000
002 A KKK 1000

Based on the above table I need to export to excel. This part is fine.
However,
I need to export to two spreadsheets corresponding to each sales person.

The first spreadsheet will look like the following:
salesid businesschannel custid amt
001 A XXX 2000
001 A YYY 3000
and the file name for excel will be 001_A.xls where 001 is the salesid and
A is the businesschannel.

Similarly the other spreadsheet will be as following:
salesid businesschannel custid amt

002 A TTT 5000
002 A KKK 1000

and the file name for the excel will be 002_A.xls with the same meaning. I
need to have this through loop so that this applies to more than 50 sales
person.


The whole transfer process including creation of files need to be done by click of a button.

I am new in excel. I appreciate any help for resolution of this issue. Thanks.