Export with Button

[Sash]

I thought I had done this before in another database. I'm trying to export a
query "ExportFinal" using specifications "ExportSpecifications" to a file
with the date such as f:\RBNPS\Export\NPS092607.txt I keep getting an
invalid path error.

Dim stExpName As String
Dim stSpecs As String
Dim stExport As String


stExpName = "f:\RBNPS\Export\NPS" & Format(Date, "mmddyy") & ".txt"
stSpecs = "ExportSpecification"
stExport = "ExportFinal"

DoCmd.TransferText , stSpecs, stExport, stExpName