Jac,
I'm no network admin, but here's my 2c..

Running from the workstation obviously means that the 2000 files have be
transferred over the network prior to being opened. Assuming these files are
on the server, getting the server to do the processing will avoid this
transfer, but increase the load on the server. Only you know if this is
acceptable.
You can use CreateObject to instantiate an object on a non-local machine.
The COM call across process/network will be expensive, but hardly much
compared to transferring 2000 file. The final report can then be sent as a
single file.

However, if you have that much data to process, a DB management scheme may
be more practical, where internal queries/stored procedures can be used.

Alternatively, ADO and/or Pivot tables may be included.

NickHK

"Jac Tremblay" wrote in message
...
Hi,
We have a serious performance problem with an Excel application when it is
used on a satellite station (any one of the many there are) but there is
no
problem when the same application is used on the central server. The WAN
is
configured properly but the data to be read is always increasing and I'm
trying to find a solution to it, asap.
The problem appears because the Excel application has to open between 1500
and 2000 excel files to produce a report. This task necessarily takes a
long
time to execute because of the 256 or 512 K band width that is used.
I thought of a possible solution but wander if it possible and if it would
be good enough as performance gain. Here is my idea:
I would split the application in two and place the code that opens the
2000
Excel files in a second Excel application on the central server. Then, I
would use the first application from the satellite site and call the
process
(the second Excel application) that resides on the central server to do
the
dirty job directly on that central server where performance is acceptable.
With such a set up, will the process be faster? Will the server memory be
used or will the process be executed on the satellite site using this
station's memory?
Does any one knows?
Any ideas?
Thank.
--
Jac Tremblay