Importing a filename from a textbox

[jharaldson]

I am having trouble importing a text file into excel. I have a form that pops up and I put in the filename of the file I want to import into a textbox on the form. But when it imports it just opens the directory from which the file is located at, I want it to open the name of the file in the textbox. Here part of the code i am using:

FName = Importbox.Value

With ActiveSheet.QueryTables.Add(Connection:= _
        "TEXT;c:\test\" & FName, Destination:=Range("A1"))

Thanks
Jeremy