Programming Forums

Programming Forums (http://www.programmingforums.org/forumindex.php)

- Visual Basic (http://www.programmingforums.org/forum18.html)

- - Access (http://www.programmingforums.org/showthread.php?t=14199)

Ive created a macro that should import/export a file based of certain criteria's: filename and filedate.
\\c\desktop\"johndoe" & Right("0" & Month(Date()), 2) & Right("0" & Day(Date()), 2) & Right(Year(Date()), 2) & ".txt
when i insert the code into the field "filename" using the action "TransferText" i receive the following errors: microsoft access cant parse the expression or filename has to end in .txt or .csv. can someone inform me as to whats wrong with the code?

Thanks

Lets switch to VBA Macros again because they're easier to debug. I pulled your code from your previous post:

Option Compare Database

Option Explicit



Public Sub Import()

Dim Joe As Date

Dim John As String

Dim result As String

Jon = Format(Date, "MMDDYY")



DoCmd.TransferText acImportDelim, "3RPV EXPORT", "Johndoe*.txt", "johndoe*.TXT"

The first step would be to correctly figure out the file name. Where is the data file located? For now, I'll assume it at "C:\desktop\johndoeMMDDYY.txt" where MMDDYY is the current date:

fileDt = Format(Date, "MMDDYY")

fileNm = "C:\Desktop\" & "johndoe" & fileDt & ".txt"

MsgBox (fileNm)

I put the MsgBox to display the final filename. If this is the correct file name, use it in TransferText and this should work.