Posted to microsoft.public.excel.programming

Bill Manville Bill Manville is offline

external usenet poster

Posts: 473

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
After OpenText all pastes from external apps use format from OpenText	Jim[_31_]	Excel Programming	1	November 8th 03 02:17 AM
Workbooks.OpenText	Alistair Eberst	Excel Programming	2	October 21st 03 12:50 PM
Using Workbooks.OpenText to read a tab-delimited file into a worksheet	Dan E[_2_]	Excel Programming	0	August 19th 03 08:02 PM
How do I unprotect cells when using OpenText function?	Scott Lyon	Excel Programming	1	August 18th 03 10:07 PM
OpenText bug ?	Orlando Magalhães Filho	Excel Programming	0	August 1st 03 04:14 AM

All times are GMT +1. The time now is 05:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us