Exporting data into MULTIPLE Spreadsheets

[Gagnon 30]

I am trying to export a table from access excel spreadshhet.. but not in the simple traditional way.

I have 140 lines of data, I need a marco to take this single table and 140 lines and create 140 spreadsheets one each line of data appearing on one of the sheets. Id also need the title of the spreadsheet to be in one of the fields in the actual spreadsheet.

Can this be done?



If I was vague.. I can elaborate morre or use grpahics to explain!

[irish634]

This can be done by looping through each record of the table, export the data for each line and assign a unique file name.