system resources

bjr157 · Mar 18th, 2002, 12:19 PM

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 · Mar 18th, 2002, 04:24 PM

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 · Mar 18th, 2002, 04:28 PM

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

Mar 18th, 2002, 04:28 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	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 __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 18th, 2002, 12:19 PM	#1
bjr157 Board Regular Join Date: Mar 2002 Location: Philadelphia Posts: 100	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.

Mar 18th, 2002, 04:24 PM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	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