ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Virtual Memory Macro (https://www.excelbanter.com/excel-programming/332548-virtual-memory-macro.html)

Roy Harrill

Virtual Memory Macro
 
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[_4_]

Virtual Memory Macro
 
Start - Control Panel - System - Advanced (tab) - Settings - Advanced
(tab) - Change

--
HTH...

Jim Thomlinson


"Roy Harrill" wrote:

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




Roy Harrill

Virtual Memory Macro
 
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

"Jim Thomlinson" wrote in message
...
Start - Control Panel - System - Advanced (tab) - Settings - Advanced
(tab) - Change

HTH...
Jim Thomlinson

"Roy Harrill" wrote:

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




All times are GMT +1. The time now is 05:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com