| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
URGENT! Expunge Excel from Memory
These are great suggestions. Thank you both very much!
"Perico" wrote: Is there a fool proof way to expunge Excel from memory? I'm manipulating Excel from Access 2003. Even when I use the following methods, I'm still finding Excel.exe in Process in the Windows Task Manager: Dim xlAppMst As Excel.Application Dim xlBookMst As Excel.Workbook Dim xlSheetMst As Excel.Worksheet Set xlAppMst = CreateObject("Excel.Application") Set xlBookMst = xlAppMst.Workbooks.Add Set xlSheetMst = xlBookMst.Worksheets(1) xlSheetMst.Visible = True xlSheetMst.Cells.Select Selection.NumberFormat = "@" xlSheetMst.SaveAs fNameMst .....other code here xlBookMst.Close Set xlSheetMst = Nothing Set xlBookMst = Nothing xlAppMst.Quit Set xlAppMst = Nothing |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XL 2007 - Out of Memory - memory leak/bug? | Excel Discussion (Misc queries) | |||
| IME MODE FOR EXCEL 2007 (URGENT URGENT) | Excel Discussion (Misc queries) | |||
| Excel VB Out of Memory | Excel Discussion (Misc queries) | |||
| The instruction at "0x65255ac9" referenced memory at "0x00000008". The memory could not be read. Clikc OK to terminate etc | Excel Programming | |||
| URGENT - Visual Basic Out of Memory | Excel Programming | |||
![Perico[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
