importing text file into excel file using macro

Hi ,

I am working on a macro to import text files into excel .but when I am executing it, I am getting an error message "Invalid procedure call or argument" at

With ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;" & FileName _
, Destination:=Range("$A$1"))

pls help...

Please Login or Register  to view this content.

Have you tried using the Macro recorder?

Thanks for your reply,

I want to execute this with a button click..hence i didn't tried macro recoder ...

Hi,

I got the solution for the above problem...

Please Login or Register  to view this content.