Question

Locked

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

By sharmila29 ·
Hi,

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.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums