Programming Forums - VB using Access

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

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

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

ok I need some serious help, for anyone that knows Access. I'm trying to automate a process using a macro that will import/export a file by the file name and date. EX: johndoe101907.txt. how can i do this? i'm using a macro action called transfertext and here's my code:
\\c\desktop\"johndoe" & Right("0" & Month(Date()), 2) & Right("0" & Day(Date()), 2) & Right(Year(Date()), 2) & ".txt"

this gives an error of file must contain .txt at the end.
so i tried to code it using vb and heres my code for it:

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"

again any help would be appreciated, I know that something here is wrong, but don't know what.
Thanks

End Sub

Re: VB using Access

Have a look at the rules, and the "How to Post a Question" thread.

Re: VB using Access

Quote:

Originally Posted by DaWei (Post 135320)

Have a look at the rules, and the "How to Post a Question" thread.

so basically you cant help me,
Thanx

Re: VB using Access

"Won't" is the word.

Re: VB using Access

I don't know how you can expect help when you didn't even ask a question. Read the rules.