i have a macro that loads 250 txt files (inside a loop) and do some things with them.
im using this code to open the file, is there any way to open all the files in the same workbook (now i see an excel window appearing and dissapearing 250 times in taskbar). I think it can speed up a little my macro.
        Workbooks.OpenText Filename:=NombreArchivo _
            , Origin:=xlMSDOS, StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote _
            , ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=True, Comma:= _
            False, Space:=False, Other:=False, FieldInfo:=Array(Array(1, 1), Array(2, 1) _
            , Array(3, 4), Array(4, 1), Array(5, 1), Array(6, 1), Array(7, 1), Array(8, 1), Array(9, 1), _
            Array(10, 1), Array(11, 1), Array(12, 1), Array(13, 1), Array(14, 1), Array(15, 1), Array( _
            16, 1), Array(17, 1), Array(18, 1), Array(19, 1), Array(20, 1), Array(21, 1)), _
            DecimalSeparator:=".", ThousandsSeparator:=" ", TrailingMinusNumbers:=True
I'll better explain what I do, i open that workbook from a TXT select ALL and paste it in one of the 12 sheets of my workbook (starting from A2 because i have the titles in the row 1). Is there any way to load the files in one step the there or the copy paste i do is necesary?

thanks and sorry for my english

Alex