OpenText very slow

  • Thread starter Thread starter nicoll
  • Start date Start date
N

nicoll

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.
 
1. Perhaps you are using files from a server, when copying to your
hard drive first might help.

2. Try Application.Calculation =xlManual


Regards
BrianB
========================================================
 
Nicoll said:
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.
Click to expand...

Application.Calculation = xlManual ?

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