Virtual Memory Macro

[Roy Harrill]

Hello Everyone,
Windows XP keeps telling me my virtual memory (aka swap file) is low,
especially when I'm working in Excel. Is there a way to program a macro in
Excel that would tell me how much virtual memory I have in total and how
much is being currently used? Or ids there something in Windows XP itself
that provides this info? Thanks in advance.
Roy

 

[Jim Thomlinson]

Start -> Control Panel -> System -> Advanced (tab) -> Settings -> Advanced
(tab) -> Change

 

[Roy Harrill]

Thanks, Jim. Yes, that's the way to drill down and see (and set) the swap
file size. I was hoping there was a way, perhaps via the Windows API, to
write a macro that would tell me the more important number, i.e., the size
and percentage of the swap file in use.
Roy

Start -> Control Panel -> System -> Advanced (tab) -> Settings -> Advanced

(tab) -> Change

HTH...
Jim Thomlinson

:

Hello Everyone,
Windows XP keeps telling me my virtual memory (aka swap file) is low,
especially when I'm working in Excel. Is there a way to program a macro in
Excel that would tell me how much virtual memory I have in total and how
much is being currently used? Or ids there something in Windows XP itself
that provides this info? Thanks in advance.
Roy