View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mrt mrt is offline
external usenet poster
 
Posts: 70
Default Cleaning the page file

Hi,

We're using dlls in c++ to perform some computations. We noticed that if we
pass objects (tables of doubles for example) to the c++ dll intensively, the
pagefile is getting bigger and bigger up to the crash of Excel (if we do
thousands of calls). In the task manager we see the page file increasing
little by little.

Is there a way we can clean using VBA what seems to be an exchange buffer.
The only way we found so far is to close our xla and reopen it, which is not
satisfactory.

Thanks,

Mr. T