Vba declare api 64 bit 32 bit

' At the top of your module: works for both 32 and 64 bits
#If VBA7 Then
Public Declare PtrSafe Function GetVersionExA _			' 64 bits
        Lib "kernel32" (lpVersionInformation As OSVERSIONINFO) As Integer
#Else
  Public Declare Function GetVersionExA _				' 32 bits
        Lib "kernel32" (lpVersionInformation As OSVERSIONINFO) As Integer
#End If

Similar codes

5 votes250 views1 answer
Xlvba double quotes in string literal
VBA
1 vote263 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
15 votes305 views2 answers
Xl vba dynamic string array
VBA
0 vote234 views1 answer
Vbscript check if string contains
VBA
3 votes230 views1 answer
Excel vba read registry key value
VBA
0 vote239 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote265 views1 answer
Vba nested dictionary
VBA
0 vote257 views1 answer
Excel vba protect sheet
VBA
5 votes248 views1 answer
Vba low word from Long Integer
VBA
4 votes244 views1 answer
Excel vba Imitating the "IN" operator from python
VBA