As I am green hand, i cann't understand your meaning, can you give a much detailed explanation? for eg, which moudle are you using?
very very thanks.

There is a table tbl1,with several fields, one of them is City, with the value varies from city1 to city30.
I want to use Access Marco to automatically using function transferspreads heet to copy this tbl1 into 30 excel sheets, by the value of city. For eg, select * from tbl1 where city value=city1 , then put the selected records into excel file “\…\…\city1.xls ”,
Thus generates 30 excel files.
Is there a simple way to...