I use Excel 2000 and am trying to use a macro to open 15 small text files.
It is very slow taking several seconds to open each file.
I have removed all data manipulation from the macro and now just open the
files with Workbooks.OpenText Filename:=

Once open the text files only fill 100 cells on a spreadsheet. But it is so
slow I think I would be quicker doing this manually.

Any suggestions please.