Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
It takes a long time to format excel
Message
From
18/11/2000 23:34:29
Chrita Lee
ProMOS Technology Inc.
Hsinchu, Taiwan
 
 
To
15/11/2000 17:11:07
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00442357
Message ID:
00443423
Views:
14
>Hi,
>I have a program that creates and formats an excel spreadsheet (25 rows - 19 columns). The trouble is on my 733MHz (256K ram windows 2000) it takes less that 5 seconds after getting the data. But on a clients 400MHz (64K ram NT 4.0 SP4)it takes over a minute. Task manager on the clients reports that the CPU = 100% but I don't see any swaping. Anyone have any thoughts regarding how to increase performance for the client.
>
>TIA
>John

Hi, John:

Maybe you can put your format code in the Open event of that sheet
with VBA code.

Chris Lee
Previous
Reply
Map
View

Click here to load this message in the networking platform