Does VBA have built-in functions for extracting just the filename
from a path string? It would also be nice if I could extract the
filename minus the Windows extension. For example, I
might have this string:

"C:\tmp\files\mydata\yearly.docx"

I would need to extract the "yearly" portion. Extracting the whole
filename of "yearly.docx" would be useful too.