Determining If OS Is 32-Bit Or 64-Bit Using VBA

C

CaliKidd

Board Regular
Joined
Feb 16, 2011
Messages
173
Is there a way (perhaps using Win32API or Win64API) to determine if a system is running a 32-bit or 64-bit operating system? For example, I am running Win 7 64-bit and when I click on Computer-Properties, it shows:

System Type: 64-bit Operating System.

I'd like to capture that info via VBA, if possible. It would be helpful since there are 32-bit and 64-bit versions of the newer OS's.
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Sort by date Sort by votes
Code: 
Function Is64bit() As Boolean
    Is64bit = Len(Environ("ProgramW6432")) > 0
End Function
 
Upvote 0
Thank you! Interesting... It seems like the logic is the OS is 64-bit if "C:\Program Files" is the program directory and 32-bit if "C:\Program Files (x86)" is the case.
 
Upvote 0
I just looked it up. The logic seems to be if that environment variable returns anything or not, as that parameter probably doesn't exist in the 32-bit version.
 
Upvote 0
You must log in or register to reply here.

Similar threads

Y
  • Question Question
While 64 bit excel uses 12 cores at very high values such as 96%-99%, it uses only 1.5 GB of 16 GB RAM.
Replies
2
Views
448
ysfuyar
Y
G
  • Solved
Getting code to work in 64 Bit Excel
Replies
5
Views
994
Gborden800
G
L
  • Solved
Querying access db from excel - 32 bit to 64 bit conversion
Replies
2
Views
770
JEC
JEC
S
  • Solved
64 Bit VBA updates batch job
Replies
2
Views
541
somesoldiers
S
D
  • Solved
Adapt code to be compatible with either 64 bit or 32 bit Excel
Replies
5
Views
2K
davidam
D

Forum statistics

Threads
1,224,560
Messages
6,179,520
Members
452,923
Latest member
JackiG

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top