Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,119
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Virtual Memory Error when running Excel Justin[_10_] Excel Programming 1 August 24th 04 03:45 AM
Virtual Memory Error when running Excel Justin[_10_] Excel Programming 1 August 21st 04 12:04 AM
Is there any way I can increase the size of the virtual memory in excel while running the macro? Julie[_8_] Excel Programming 2 January 27th 04 01:58 PM
Tracking Virtual Memory Quaoar[_2_] Excel Programming 0 January 23rd 04 01:59 AM
Tracking Virtual Memory (bump) roch1009 Excel Programming 0 January 22nd 04 11:36 PM


All times are GMT +1. The time now is 10:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"