Can't find object error when using TransferText Method

[bconner]

I am trying to transfer a Query (using a Spec and without headers) to a txt file using the transfertext method and I keep getting the error 'Run Time Error 3011' Microsoft Jet Database couldn't find the object 'EmDeonTest.txt'

I am trying to simply export it to my desktop. If I could have it prompt me for a location and name that would be better however when I leave the argument blank it doesn't prompt me...


I am using the code below:

Sub ExportEmDeonFile()
DoCmd.TransferText acExportDelim, "EmDeonExportSpec", "Qry_EmDeon_File_Final", "C:\Documents and Settings\bconner\Desktop\EmDeonTest.txt", False
 
 
 
End Sub