Acces using VB
 

I created a macro that should be able to export/import a file based on the filename and date. when i insert the code:
=\\c\desktop\"johndoe" & Right("0" & Month(Date()), 2) & Right("0" & Day(Date()), 2) & Right(Year(Date()), 2) & ".txt in the filename field it gives me an error of either filename must end in .txt or .csv or microsoft access cant parse the expression. Can someone tell me whats wrong with my code? this is a macro created in access with the transferText Action.
Thanks

Re: Acces using VB
 

Duplicate question. Thread Closed.