I have an MS Access 2007 database. When the database is closed, I would like to:
A. Save the query: qry_members as a .xls file to the location: C:\members
B. Save the filename with the current date appended to the end - and a date + 24 hour timestamp. E.g If it is 8 April at 2:05pm the file would be saved as:
If this is possible, how would I do this?