Hello All,
I have a macro in Access 2007 that opens a query, filters it for a state abbreviation, then outputs that info to an excel spreadsheet. I am trying to find a way to use the parameters in the query to automatically name the file for each company and state. For example if I chose "company1" for the query and "AK" for the filter it would output all of the employees from company1 that live in alaska to the spreadsheet and save it as "...\my documents\company1_ak.xls. Any help would be great.

Thanks to all.