Too long to save an Excel file
Hi, I wrote an Excel/VBA application using a lot of modules and class
modules. the file size of this application tempate is 6.8M. It takes just
over two minute to save to network share and above a minute to save locally.
Is there any way to improve the saving time? I tried to implement the
Micosoft solution of saving it locally (c:\temp ) mostly and background copy
to the share drive and then re-opening newly coped file from the share but
the best I can hope for is about a minute. Is there anyway I can improve the
saving time significantly?
Thanks in advance.
sk005
|