| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Taking hours to save excel file
To save an excel file of about 32.602 MB size it takes 14hrs45min.
Currently it is implemented using threads in VC++. Here a stingray studio function (OnSaveDocument) is used to save the file in excel format. Working on Visual Studio 2003 How can it be reduced to about 4 hrs?? Here before saving the data to the Excel file, the values are populated to a grid after calculation. To place the value in the grid we call CGXGridCoSetValueRange(). Now to improve the performance, I changed it to CGXData:StoreValueRowCol() to place the values. Also I tried using LockUpdate() along with this. But all these did not have any effect. Please help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel files, periodically, taking a long time to save or open | Excel Discussion (Misc queries) | |||
| Excel File Taking Forever to Open | Excel Discussion (Misc queries) | |||
| Taking long time to save file to sub folder | Excel Discussion (Misc queries) | |||
| How to save file in a macro taking new name from cell contents? | Excel Discussion (Misc queries) | |||
| Apply a macro to all sheets - save me from hours and hours of work | Excel Programming | |||
Threaded Mode
