• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 615
  • Last Modified:

Excel VBA, processor speed and total system memory

Excel VBA 03/07:
Is it possible to determine via VBA the processor speed and total system memory of PC?
0
kieranjcollins
Asked:
kieranjcollins
  • 2
  • 2
1 Solution
 
Nico BontenbalCommented:
0
 
kieranjcollinsAuthor Commented:
For the memory VBA

How do I set
Sheets("Sheet").Cells(1, 1) = total memory from the code?
0
 
Nico BontenbalCommented:
See attached file. In this example I call the VBA function directly on the form. But you can use the functions
GetTotalMem()
or
GetCPUSpeed()
in VBA also (so in the place where you wrote ' total memory from the code?')
Mem.zip
0
 
kieranjcollinsAuthor Commented:
Thank you, that worked a treat
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now