file import from a module

I wish to import a comma delimited text file to a table using a VBA module.
I have succeeded doing so with this:
DoCmd.TransferText acImportDelim, "cisco Import Specification", "0901C", "0901CDR.txt"

I want to pass a variable from an input box, said variable being the first 4 characters of the text file and the import table (in this example 0901)
I get the variable like this:
TableName = InputBox("Enter a Table Name for Updating", "Input")
but I am having trouble with syntax passing said variable to the TransferText statement.

Have you tried this:

DoCmd.TransferText acImportDelim, "cisco Import Specification", TableName, TableName & "CDR.txt"

I can't see why that wouldn't work. If it errors out, what is the error message? You will have to declare TableName as a String, by the way, otherwise you could lose the leading zero.

That worked! I kept embedding the variable names in "" and '' and []. That was where it was failing.

Thank you.