View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Adrian T[_2_] Adrian T[_2_] is offline
external usenet poster
 
Posts: 11
Default Is it memory problem?

Hi:

What I have is probably not specific enough or many
possible answers to it. I apologize for that.

I have a financial model (lets say 'Model A') with heavy
Excel VBA code in it. When I execute the code, I'd get the
results I wanted in 2 seconds. But when I open another
Excel file (also with complicated code in it) and execute
the code in 'Model A', it took me 2 mins.

I tried to open 'Model A' and an empty workbook. This
doesn't make any difference than opening 'Model A' alone.
So, the fact that I have another hardcore file opened
would affect the overall performance.

Does anybody have some rough ideas of what's happening
here?


Regards,
Adrian T