I am trying to understand how to write VB code in Access 2010 to automatically populate the data into multiple excel spreadsheets. The data in the query encompasses all the data (by manager), but I need to separate the files by manager. The files need to be automatically exported to excel with the name of each manager which should give me 32 exported files. I'm new to VBA and have read posts for the last 2 days and can't figure it out.
Thanks in Advance