I have the same problem. I can't find a way to directly access the file name in VBA, but you can use the CustomInfo to link it.
In the drawing template, under the Custom tab in Summary Info (accessed from File->Properties), add a File Name (or whatever you want to call it) property which links...