Export sorted lists

  • Thread starter Thread starter Lupe
  • Start date Start date
L

Lupe

Hi,
I have a query that has personnel members with their respective departments
and additional info. I want to selectively download to Excel all personnel
but each department in their own spreadsheet.
Example: All departments starting with A will be downloaded in sheet A, all
departments starting with B will be downloaded in sheet B, etc.
Is this possible?
Regards, Lupe
 
Lupe,

You could use Office Automation to Open the Excel, create a new spreadsheet,
then loop through your recordset and write the values to each worksheet based
on the first letter of the department.

Google on: Access +Excel +Automation for some ideas on how to acomplish this.

HTH
Dale
 
Back
Top