ActiveSheet.QueryTables question

[specialk9203]

I have this code:

With ActiveSheet.QueryTables.Add(Connection:= _
        "TEXT;C:\Users\malbre1\Desktop\SilverlinkTest.csv", Destination:=Range("$A$1" _
        ))
        .Name = "SilverlinkTest"
        .FieldNames = True 

instead of using the static file path I would like to use a file path I have as a variable which equals fileA. Do you know how to insert that into my code. I've tried to replace this: "TEXT;C:\Users\malbre1\Desktop\SilverlinkTest.csv" with fileA but that doesnt work. I'm assuming I also need to keep TEXT too.

Any ideas?