Cave à vins ( avec macro) 2018-03-08

[dysorthographie]

les directives de compilation permettent de définir les librairies en fonction de la version excel.

Voici un exemple

#If Win64 Then
    Private Declare PtrSafe Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" _
        (ByVal lpBuffer As String, nSize As Long) As Long
#Else
    Private Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" _
        (ByVal lpBuffer As String, nSize As Long) As Long
#End If

 

[JM27]

les directives de compilation permettent de définir les librairies en fonction de la version excel.

Voici un exemple

#If Win64 Then
    Private Declare PtrSafe Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" _
        (ByVal lpBuffer As String, nSize As Long) As Long
#Else
    Private Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" _
        (ByVal lpBuffer As String, nSize As Long) As Long
#End If

Ah merci cela me reviens. je connaissais comme quoi comme si on l'arrête le VBA on a tendance à oublier