I have several queries in an Access 2007 database that I would like to export into one Excel file with multiple worksheets. (e.g. Queries pull tables for OH, MI, and IN, I would like one Excel file called "District.xls" with three worksheets for OH, MI, and IN.) I would also like to keep the formatting intact when the files export (so the headers look pretty, bold, grey background, etc.)
My import and data scrubbing module is in the Access file, so I would prefer to stay in Access if possible. Otherwise, if I need to move to Excel to do this, I am not too terribly attached to doing it in Access.
I am very comfortable with VBA, but my google searches have not produced a "silver bullet" per se. It's mostly sharing worksheets, linking tables, and the like. So, 350 points to the person who can get me what I need, please.