excel2003 memory problem

[nodari]

hi

I have problem with memory when I open my excel file. the excel file itself is 6MB and takes 600MB in memory when is open (looking from task manager's performance).

advice me please what to do.

 

[xenou]

This sounds like a serious problem - I cannot imagine any reason for a workbook to use up so much memory. Are you sure you are interpreting the task manager data correctly? Can you say what is the actual figure you are reading (before and after opening the workbook), and for what kind of memory?

ξ

 

[nodari]

This sounds like a serious problem - I cannot imagine any reason for a workbook to use up so much memory. Are you sure you are interpreting the task manager data correctly? Can you say what is the actual figure you are reading (before and after opening the workbook), and for what kind of memory?

ξ

I think I make no mistake interpreting the task manager. maybe its becaus of VBA which uses quite big memory? but anyway, the usage is maximum as soon as I open the workbook...

 

[nodari]

I think I make no mistake interpreting the task manager. maybe its becaus of VBA which uses quite big memory? but anyway, the usage is maximum as soon as I open the workbook...

I continue expertizing and seem that it happens because of my macro. so the problem is how to free memory after the VBA macro finishes work ?

 

[nodari]

I continue expertizing and seem that it happens because of my macro. so the problem is how to free memory after the VBA macro finishes work ?

I use Dim saq(0 To 20000) As MyType (it has many subtype). I change 20000 to 2000 and push to save the workbook. the usage of memory from 1,4GB went to 850MB at once. after I cnaged 2000 to 20000, but usage of memory stays 850MB, until I don't use the VBA.

so now I need if possible do this automatically - after VBA finishes its work, let it free the memory at once ?!...

 

[xenou]

It's hard to say without knowing more specific information about your vba program and how it works.

 

[nodari]

It's hard to say without knowing more specific information about your vba program and how it works.

I use ReDim and it helps, I fit it before end of sub.