| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.sdk,microsoft.public.excel.worksheet.functions,microsoft.public.office.developer.vba
|
|||
|
|||
QUERY: Excel's SaveAs so slow..
Just wondering if anyone knows about Excel's SaveAs command?
I load up a Excel file via VNC on a server on the otherside of the world. I got a macro which does a SaveAs command to a network drive which is my local HD. It takes over 12 minutes to do a save of a file only 600kb. Is this normal? The macro however does run a lot of formating and data parsing/entry from an XML file, so I guess a lot of memory would be consumed. Maybe if I free up the memory before the save? But in Excel you cannot free up memory easily. There's no memory management commands, and no garbage collection. Would it be quicker to issue a copy or maybe move command? Because I used Windows Explorer to copy the 600kb excel file from the server to my local drive and it took seconds! So maybe it's Excel '97 really slow SaveAs command? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Very slow using SaveAs in Excel (and other Office apps) | Excel Discussion (Misc queries) | |||
| QUERY: Excel's SaveAs so slow.. | Excel Worksheet Functions | |||
| QUERY & HELP: so slow executing VBA code... :S | Excel Worksheet Functions | |||
| File saves ok, SaveAs VERY slow | Excel Discussion (Misc queries) | |||
| SaveAS macro Query | Excel Discussion (Misc queries) | |||
Threaded Mode
