Changing a file name

[RayMilhon]

I have a couple of queries that are run weekly. The results are exported to Excel and the Excel files are emailed to the user. I have this set up to run Every Monday at 5 AM so the user has the data is his inbox when he comes in to work. What I'd like to do is include in the VBA so the file name is changed after the email is sent to create a history of the files that were sent.



For example:
The Data is exported to Claim_Audit_Facilities and Claim_Audit_Professional Excel Spreadsheets and emailed to the User. After that is completed I want to change both file names to include the underscore and the rundate. So the filename would change to Claim_Audit_Facilities_12272017 and Claim_Audit_Professional_12272017.

[June7]

Why not assign those suffixes to the file name before sending?

This works for me:

Name "C:\Users\June\MyStuff\DMV.pdf" As "C:\Users\June\MyStuff\DMV2.pdf"

Post your code if you need help adapting.

[RayMilhon]

The storage of files sent is for my purpose only the user doesn't want or need it. That's why I want to change the name after the file is sent. First it gives me a history of what was sent since this process will be automated. Second I can see as soon as I come in if there was an issue with the sending of the files even if I've been on vacation for a couple of weeks.

[June7]

So the user doesn't really care what the file name is? If it simplifies the process to name before sending then why not?

As I said, post your code if you need help adapting the method to your procedure, whichever way you want to use it.