Error Allocating Memory

[nbala75]

I use ExcelreadsheettoArray and copy around 5000 rows of data into an array. The size of the excel file is around 3MB.

And then, i open a While loop to get parameters thru an Inputbox.

Using those parameters, i make some calculations on the excelarray and store the result in a Notepad file. The size of the notepad file comes to around 200K.

I do this way bcos, there are multiple ways in which this calculations can be done, and i dont want to use ExcelreadsheettoArray every time since it takes more time each time when i wish to change the parameter and re-run the code.

So when i give input for around 4 or 5 times, i get this error "Error Allocating Memory".

What causes this error to happen and Is there a better way to do my work?

Thanx again for ur help

Edited March 3, 2011 by nbala75

[KaFu]

"Error Allocating Memory" says you're running out of RAM. With the figures you're mention above, this sounds to me like you're not freeing up variables behind you correctly and / or are duplicating variables (in a large loop?). Can't point out the details without some code provided ...

[nbala75]

Ok

I dont know which part of the code to put it here

If u can provide some links to Help topics on Freeing up Variable, i will go thru it and get back to u

Thanx

[KaFu]

$var = 0 will delete a variable, $aArray = 0 will delete an array, it's quite easy in fact, if you don't need them anymore, delete them. Note that local variables and arrays will automatically be freed when function finishs (help-file pages to read: "Dim / Global / Local / Const", "Language Reference - Variables").

Edited March 3, 2011 by KaFu

[guinness]

What KaFu said and maybe using the "Reduce Memory" Function which can be found in WinAPIEx.au3 by Yashied, search for _WinAPI_EmptyWorkingSet()

[nbala75]

Kafu

think i have been indiscriminately using Global

So let me check that and get back

thanz again

thanx to Guinness...let me look for that as well