transfertext problem

[Greg25]

can some one look at this and tell why its not working


Private Sub ExportText_Click()
Function export_palm_text()
On Error GoTo export_palm_text_Err

DoCmd.TransferText acExportDelim, "export", "Status change for palm", "C:\Palm\Barbar\CatScan\Downloads\Status change for palm", True, ""


export_palm_text_Exit:
Exit Function

export_palm_text_Err:
MsgBox Error$
Resume export_palm_text_Exit
End Sub


am not good at debugging

if i doit through file export works fine
macro gives me error read/only

thanks Greg

K & G Design
kgdesign@warwick.net

 

[Greg25]

think i figured it out
file name needs .txt

Thanks Greg

K & G Design
kgdesign@warwick.net