Here is a small macro that I made to save in PDF or DXF with an additional annotation, by modifying it a little bit you can manage to do something nice!
According to the Solidworks help, to get the revision you need
ISldWorks
Dim value As String
value = instance.RevisionNumber()
I don't know how you created your macro for PDF afterwards, but if we did it the same way, you add at the end of the line of the name which gives something like this
Edit: Oops, I didn't see that you wanted a full macro. David's must be very good then. (If you want another one, I had posted one in the dictaciel with explanations on each line)
I tried a few hacks on my side too, but nothing conclusive.
However, I'm afraid you'll have to create a review table to do what you want. This would then allow you to obtain the revision number of the table and therefore include it in your registration name.... All that's left to do is find out how to do it :s