I'm running Access 2010. What I want to achieve is:
1. Build a command to run a number of queries in Access.
2. Save the query results in Excel files and store them into separate folders on a network directory. (File names will not change)
3. Having the first line in each of the Excel files stating the query name and the date and time stamp when it was done.
ex: Query name (three spaces) File last updated on Aug 27., 15 at 3:00 PM