How much RAM in system?

[CLR]

Hi All.........
Could someone please give me the code to return the amount of RAM installed
on the system?

TIA
Vaya con Dios,
Chuck, CABGx3

 

[urkec]

Glad that was of some help . I wasn't aware that you were using Office 97,
what is you version of Windows? My code uses WMI and I haven't used WMI on
any Windovs prior to Win 2000. Anyway, glad to help.

 

[CLR]

Thanks for the response John, but that's not what I'm after.
I'm trying to identify the total amount of Installed RAM...........

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

Hi urkec............Thank you very much, that works really well. I had sent
you a thank-you note some time back, but I still don't see it posted. I
guess the Ether-Gods got it somehow. Anyway, what I wanted to ask further is
if you could be so kind as to trim that down some for my need. What I'm
trying to do in Excel 97 is.......

Application.GoTo Reference:="R65000C4"
Selection.End(xlUp).Offset(1, 0).Select
Selection.Value = "TOTAL RAM HERE"

Application.GoTo Reference:="R65000C5"
Selection.End(xlUp).Offset(1, 0).Select
Selection.Value = "FREE RAM HERE"

I do very much appreciate your help.....

Vaya con Dios.
Chuck, CABGx3

 

[CLR]

This machine here at work is P3 864Mhz, 512MB RAM, and has Windows XP Pro and
your code works fine on it with Excel 97, Excel 2000, and Excel 2002.

My machine at home is AMD 1.2Ghz, 512MB RAM, and has Windows Me, and your
code works fine on it with Excel 97 and Excel 2000.

The work machine is on a network. The home machine runs 4 times faster than
the work machine on Excel. The home machine also has about 100MB more free
RAM than the work machine although both have the same size RAM installed, and
only Excel is open at the time of test.

Many thanks again,
Chuck, CABGx3