Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Runtime Error '7': Out of Memory
I am trying to use vba in excel to open several excel files and format them
to what I need. When I run the procedure, I keep getting Runtime Error '7': Out of Memory. I have tried running the procedure with nothing else open and I do not understand how I could be out of memory. I am using Excel 2002. I created a smaller procedure in a new excel file to test and still got the error. Here is the code from my test procedu Public Sub test() Dim xlApp As Excel.Application Dim wb As Excel.Workbook Dim str As String Set xlApp = CreateObject("Excel.Application") xlApp.Visible = True str = "C:\temp\test.xls" Set wb = xlApp.Workbooks.Open(str, False, True, , , , , , , False) xlApp.Quit Set xlApp = Nothing End Sub The error occurs on the line "Set xlApp = CreateObject("Excel.Application")". I have tried using the line "Set xlApp = New Excel.Application" and the error still occurs. Also, when I close out of excel and try to open a new excel file, I get a dialog box telling me that excel did not open properly last time and suggests that I open excel in safe mode. Can anyone please help me? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Runtime Error "7": Out of Memory | Excel Programming | |||
Runtime Error 7, Out of Memory | Excel Programming | |||
Excel:Runtime Error 7 "Not enough Memory" with CreateObject (SAP.B | Excel Programming | |||
Syntax Error Runtime Error '424' Object Required | Excel Programming |