I'm sure this has been answered, and I've looked but can't quite find
what I'm looking for.
I have
Path = "I:/voucher.txt"
DoCmd.TransferText acExportFixed, "voucher_fixed", "voucher_creation",
Path, No
This runs the query voucher_creation. During that query the user is
asked to input a string "1234". I want to insert the string into the
file name when it's output. So file would be "1234voucher.txt". I'm
not clear how I tell it to add something to the output. (I'm not well
versed in how to pass variables between the query and my procedure if
that's what's needed.