First, it is possible for you to rename a file from one path to another path on the same drive (which appears to apply to the case you posted).
The following is AIR CODE in that it only is meant to demonstrate a principle. This means I am not even going to bother to DIM anything.
SrcFldr = "B:\FOR REVIEW\"
SrcFile = "16JUN19-DDB-001.PDF"
DstFldr = "B:\COMPLETED\"
DstFile = "16JUN19-DDB-001DONE.PDF"
SrcSpec = SrcFldr & SrcFile
DstSpec = DstFldr & DstFile
Name SrcSpec As DstSpec
How you go about filling in the file name and folder for each of the components is up to you, but I broke it down into parts just so you could see how to combine the parts once you have them all.
Note also that this only works as you requested if the source and destination are on the same drive. If this crosses physical drives, you need other syntax.
There is also the idea that you could use a File System Object, which would give you access to a whole range of file operations.
The available methods are listed in the linked article. These methods include file copy, file delete, file rename, and a few other useful abilities.
For simplicity, the original "Name As" will work but is limited. For generality, use the File System Object to do full file manipulation.