Hi All,
I have been working with my boss on an access database that compiles a list of daily charges and creates an excel document in a shared folder. Currently, I am going into the database each day and running the macro my boss created. The file is created with the following name: MTProfessionalCharges.xlsx. I then have to go into the shared folder and change the excel file name with today's date. For example, today's file (6/10/14) would be renamed as "2014.06.10MTProfessionalCharges.xlsx." Is there a way alter the macro so the file name does not need to be changed? Attached is how the macro currently looks in Access 2010. I do not have a programming background so please simplify the solution as much as possible.
Thanks!
Martha