VBA to determine if user is running 64bit Excel or 32bit Excel

[Mxer911]

As the title states I'm looking to create a VBA that checks and determines if the user is running 64bit Excel or 32bit Excel. Any and all help is greatly appreciated.

 

[perco754]

http://www.mrexcel.com/forum/showthread.php?t=542727

 

[Mxer911]

Thanks for the quick reply, however this looks to be used in determining the OS is 32 or 64, however you can still install 32 or 64 office 2010 on a 64 bit system, so I'm looking for coding that will determine whether excel is 32 or 64.

 

[Richard Schollar]

I think you can do this using Conditional Compilation:

Sub test()
Dim bIs64Bit As Boolean
#If win64 Then
    bIs64Bit = True
#End If
MsgBox "This is 64bit office: " & bIs64Bit
End Sub

 

[Bieli]

Using "environ" function you can get procesor version but it's not info is excel 32/64 bit.

 

[Mxer911]

Thanks everyone for the help, but looks like Richard has come thru on this one! Thanks again!