OpenText very slow
 

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.

OpenText very slow
 

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" wrote in message ...
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.

OpenText very slow
 

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