| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel+Not Enough Memory..
-----Original Message----- Hi Olly Try this on the sheet Sub Mail_ActiveSheet1() Dim strDate As String ActiveSheet.Copy Cells.Copy Cells.PasteSpecial xlPasteValues Cells(1).Select Application.CutCopyMode = False strDate = Format(Date, "dd-mm-yy") & " " & Format (Time, "h-mm-ss") ActiveWorkbook.SaveAs "Part of " & ThisWorkbook.Name _ & " " & strDate & ".xls" ActiveWorkbook.SendMail ", _ "This is the Subject line" ActiveWorkbook.ChangeFileAccess xlReadOnly Kill ActiveWorkbook.FullName ActiveWorkbook.Close False End Sub -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl and now its back to out of memory error .. hmmm olly |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| not enough memory to print excel ws in 7 | Excel Discussion (Misc queries) | |||
| XL 2007 - Out of Memory - memory leak/bug? | Excel Discussion (Misc queries) | |||
| Excel VB Out of Memory | Excel Discussion (Misc queries) | |||
| Memory Leak in Excel | Excel Discussion (Misc queries) | |||
| no enough memory to run excel viewer | Excel Discussion (Misc queries) | |||
Threaded Mode
