Nicoll wrote:
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.


Application.Calculation = xlManual ?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup