system resources

[bjr157]

is there anyway to check your system resources in VBA code? I'd like to insert a section into a macro that stops the macro if resources (RAM) gets too low. the reason is that i periodically get an error message like "out of memory" in the middle of my macro.

 

[dk]

Hi,

You could have a look here at the GlobalMemoryStatus API call.

http://www.vbapi.com/ref/g/globalmemorystatus.html

Let me know if you need any help with the code.

Regards,
D

 

[Jack in the UK]

Hi

Hi dk hope you fine, over there about 2 / 3 miles or so away!

OK... Look what Opperating System are you on.. this is teh issue, what spec PC ie Chip and memory foprget the rest