Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving takes soooo long
I have an Excel file that contains a couple userforms and plenty of VB in
about 60 different Sub's. When I save the file the save process seems to take about 3 to 4 times longer than saving an excel file without macros. Is this my immagination or do UserForms, Modules, etc slow the save process? Is there anything to do to speed up the save process? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving takes soooo long
Try cleaning up your Temp directory, this might help.
Start--Run--%Temp% Charles ______________________ Decision Models FastExcel 2.3 now available Name Manager 4.0 now available www.DecisionModels.com "Paul D." wrote in message ... I have an Excel file that contains a couple userforms and plenty of VB in about 60 different Sub's. When I save the file the save process seems to take about 3 to 4 times longer than saving an excel file without macros. Is this my immagination or do UserForms, Modules, etc slow the save process? Is there anything to do to speed up the save process? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving takes soooo long
Although there was lots to delete from the temp directory this had no effect
on the lengthy save process for this particular excel file. "Charles Williams" wrote: Try cleaning up your Temp directory, this might help. Start--Run--%Temp% Charles ______________________ Decision Models FastExcel 2.3 now available Name Manager 4.0 now available www.DecisionModels.com "Paul D." wrote in message ... I have an Excel file that contains a couple userforms and plenty of VB in about 60 different Sub's. When I save the file the save process seems to take about 3 to 4 times longer than saving an excel file without macros. Is this my immagination or do UserForms, Modules, etc slow the save process? Is there anything to do to speed up the save process? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving in Compatibility mode takes a long time | Excel Discussion (Misc queries) | |||
Clearing cells takes long, long time | Excel Discussion (Misc queries) | |||
Saving files in the same network directory takes too long time!! | Setting up and Configuration of Excel | |||
Recalculation takes too long - help!!!! | Excel Worksheet Functions | |||
Saving Takes long time | Excel Programming |