I was looking for some code that will take the current file name and use
'Save As' to name it with the current path:
G:\COMMAND-CENTER\Accounts\account name\name PMR\***the new file name as
'name PMR mm/dd/yyyy'

This name will need to reflect the previous day's date.

Any help would be appreciated!

Thanks
--
EW - Analyst