I have developed a macro that opens large text files (each has a list of
about 50,000 lines, almost all single numbers), reads them one at a time, and
places each one in a successive column.

The method I used is to open a text file, copy column A, paste it into the
next available column in the main sheet, close the text file, and repeat for
all text files in a folder (there could be up to 100 of them).

I am finding it could take about a minute to run this macro (for 35 files).

My question: will I gain speed by using the command "Open FileName For Input
As #FileNum"? (I would try it myself; since there's a learning curve for me,
I'm hoping to get somebody's input first.)

Thanks.