| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Memory Leak
I'm opening 5 workbooks, and copying in sheets from each
workbook. After 5 iterations I get "copy method of worksheet class failed" on the copy command. I monitored application.memoryused. The number starts at around 450,000, jumps to 2,900,000, and climbs from there. The best solution that TechNet provides is to close the application frequently, to avoid running out of memory. Any better solutions? Thanx! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Memory Leak
You could look into using API calls to clear the clipboard.
Keith www.kjtfs.com --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Charts & Memory Leak?? | Excel Worksheet Functions | |||
| XL 2007 - Out of Memory - memory leak/bug? | Excel Discussion (Misc queries) | |||
| Memory Leak in Excel | Excel Discussion (Misc queries) | |||
| Memory leak query | Excel Discussion (Misc queries) | |||
| Memory Leak using ADO 2.6 | Excel Programming | |||
![GSS[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
