Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
45 seconds to save a file, why so long?
Why would this code:
If sSaveFolder < "Rollup" Then ActiveWorkbook.SaveAs FileName:=sSaveLoc & "\" & sSaveFolder & "\" & sBranch & "_" & sPeriod & "_Ops_Rvw_Pckg" & ".xlsm" _ , FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False Else ActiveWorkbook.SaveAs FileName:=sSaveLoc & "\" & sBranch & "_" & sPeriod & "_Ops_Rvw_Pckg" & ".xlsm" _ , FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False End If take 45 secs to save a .5mb file when I can manually save the same file and it only takes a couple of seconds? Is there anything I can do to speed up this process? I'm already saving to my hard drive instead of to a network location. Thanks, Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Too long to save an Excel file | Excel Programming | |||
why would a large addin save in 2 seconds or 18 seconds | Excel Programming | |||
I can't save long file names, only short one, how can I do this? | Excel Discussion (Misc queries) | |||
Long Save Times with File-Save | Excel Discussion (Misc queries) | |||
Excel file takes a long time to save | Excel Discussion (Misc queries) |