Problem exporting tables to text file and save it with the current date!

By sharmila29 ·

I am trying to append the current date to the txt file I am saving with docmd acExportDelim command so I can review it later if deen necessary. My sub is inlucded below. If I dont' include the date, the file is getting stored, but when I include the date its highlighting my command. Any help will greatly appreciate.

Private Sub Command0_Click()

DoCmd.TransferText acExportDelim, "","Employees","C:\Users\shari\Desktop\exemployee" &date & ".txt", False"

End Sub

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums