VBA code stops with no Error!

[liiamra]

Dear All,

I have developed some algorithms for organizing and analyzing a large dataset of Excel files (2GB). Each algorithm is included in multiple modules, and hence they are very long to display here.

When I try the codes with small datasets (few Excel files, 10 for example), it works with any computer irrespective of the specifications. When I try to work with the whole dataset, however, the process halts in the middle without giving any kinds of errors. This problem disappears if I use a 2X Xeon QC old XP computer!

I have extensively searched the web for better understanding, but haven't reached any conclusions.


Could anyone advise please?
Thanks in advance-

 

[liiamra]

Guys, this is the second time I post similar topic in ~one month and I get no reply.

Isn't there anyone familiar with the topic? A little strange for me
Regards

 

[Norie]

You don't really give a lot of details and you haven't posted any code.

That kind of makes it hard to comment or make suggestions.

Can you post more details and an example of the code?