Interesting, it was the filename. I put a .txt at the end and the code ran normally except for this twist. It converted all the dots "." to hashes "#", e.g. PVA#02012016#PRS#R8452.txt instead of PVA.02012016.PRS.R8452.txt which may be why this step was never automated. Here's my solution which uses file naming functionality, something I hardly ever use, mostly because I don't know how, or didn't.
Code:
strSSAFilePath = "\\xxxxxxxxxx\FIMSData\SSA_Reporting\SSA_Data"
strSSAFilePathName = strSSAFilePath & "\EVSPRSN" & Format(Me.RptBegDate, "yyyymmdd") & ".txt"
DoCmd.TransferText acExportFixed, "EVSPRSN_Export", "EVSPRSN", strSSAFilePathName, False, ""
strSSAFilePath = strSSAFilePath & "\SSA_Format"
strSSAFilePathName = strSSAFilePath & "\PVA." & Format(Me.RptBegDate, "mmddyyyy") & ".PRS.R8452.txt"
DoCmd.TransferText acExportFixed, "EVSPRSN_Export", "EVSPRSN", strSSAFilePathName, False, ""
strFileName = "\PVA#" & Format(Me.RptBegDate, "mmddyyyy") & "#PRS#R8452.txt"
Name strSSAFilePath & strFileName As Left(strSSAFilePathName, Len(strSSAFilePathName) - 4)
MsgBox "Your data has been exported to " & strSSAFilePathName & "."
Application.FollowHyperlink strSSAFilePath
The surprising part is that it works! Hooray for me.