File Name Argument

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to import a text file, with the path chosen by the user. The file
name argument is a function (TestIt2) that allows the user to browse for the
file.

DoCmd.TransferText acImportDelim, "", "tblData", TestIt2(), True, ""

When I run the code, I get the appropriate window to browse for the file,
but when I file is selected I get a "action or method requires a file name
argument" I've tried =TestIt2, but no luck. Help!
 
Chances are that the TestIt2 function is returning just the file name? It
needs to return the entire path and filename, and be sure that it returns
this value as a string.
 
Back
Top