Scraping data from WIFI networks that are available

[johnnyL]

Ultimately, I would like to combine the results from the following onto one sheet:

1) CreateObject("WScript.Shell").Run "cmd /c netsh wlan show networks mode=BSSID" & _
"|clip""", 0, True
specifically:
SSID, Networktype, Authentication, Encryption, MAC Address (BSSID), Signal level, Radiotype, Band, & Channel ... I have the code to do this

2) Data scraped from WLAN_AVAILABLE_NETWORK
specifically:
uNumberOfBssids, uNumberOfPhyTypes, dot11PhyTypes

3) Data scraped from WLAN_BSS_ENTRY
specifically:
lRssi, uLinkQuality, usBeaconPeriod, ullTimestamp


The code I have for getting the data from WLAN_AVAILABLE_NETWORK works perfectly.

The problems I encounter is when I try getting the data from WLAN_BSS_ENTRY.

The problems seem to be multiple.
The gathering of data from WLAN_BSS_ENTRY only occasionally works for the first row of data, most of the time it produces 'garbage' info. All additional rows seem to result in 'garbage' info.

I would tend to think that the issue is a memory pointer issue not being incremented properly.

I have also noticed that the WLAN_AVAILABLE_NETWORK section that works perfectly, doesn't 'jive' with the results from WLAN_BSS_ENTRY ... ie. The SSID's aren't matched up.


Any help would be most appreciated. Probably serves me right for delving into this area of API's and such that I am not used to dealing with.

Perhaps someone such as @Jaafar Tribak or others that are wise to this approach of 'scraping' data could assist.

The following is the code I am currently trying to use to scrape the data from WLAN_AVAILABLE_NETWORK & WLAN_BSS_ENTRY:

Option Explicit
'
    Private Const DOT11_SSID_MAX_LENGTH                 As Long = 32
    Private Const WLAN_MAX_PHY_TYPE_NUMBER              As Long = 8
    Private Const DOT11_RATE_SET_MAX_LENGTH             As Long = 126
'
    Private Type GUID
'        data1                                           As Long                         '   The first 4 bytes of the GUID.
'        data2                                           As Integer                      '   The next 2 bytes of the GUID.
'        data3                                           As Integer                      '   The next 2 bytes of the GUID.
'        data4(7)                                        As Byte                         '   The last 8 bytes of the GUID as an array of bytes.
        Data(15)                                        As Byte                         '   The entire 16 bytes of the GUID as an array of bytes.
    End Type
'
    Private Type WLAN_INTERFACE_INFO
        interfaceGuid                                   As GUID                         '   The globally unique identifier (GUID) of the WLAN interface.
        strInterfaceDescription(255)                    As Byte                         '   The description of the WLAN interface as an array of bytes with a maximum
'                                                                                       '           length of 255 characters.
'        IsState                                         As Long                         '   The current state of the WLAN interface.
    End Type
'
    Private Type DOT11_SSID
        uSSIDLength                                     As Long                         '   The length of the SSID (Service Set Identifier) in bytes.
        ucSSID(DOT11_SSID_MAX_LENGTH - 1)               As Byte                         '   The array of bytes that stores the actual SSID data.
    End Type
'
    Private Type DOT11_MAC_ADDRESS
        DOT11_MAC_ADDRESS(5)                            As Byte
    End Type
'
    Private Enum DOT11_BSS_TYPE
        infrastructure = 1                                                              '   An infrastructure network, which is a traditional Wi-Fi network with access
'                                                                                       '           points (APs).
        independent = 2                                                                 '   An independent or ad-hoc network, where devices communicate directly with
'                                                                                       '           each other without the use of an access point.
        Any_ = 3                                                                        '   Any BSS (Basic Service Set) type, which includes both infrastructure and
'                                                                                       '           independent networks.
    End Enum
'
    Private Enum DOT11_PHY_TYPE
        unknown = 0                                                                     '   An unknown or unspecified PHY type.
        Any_ = 0                                                                        '   Any PHY type. Note that "Any_" is used instead of "Any" due to the reserved
'                                                                                       '           keyword "Any" in VBA
        fhss = 1                                                                        '   Frequency-hopping spread spectrum (FHSS) PHY type
        dsss = 2                                                                        '   Direct-sequence spread spectrum (DSSS) PHY type.
        irbaseband = 3                                                                  '   Infrared baseband PHY type.
        ofdm = 4                                                                        '   Orthogonal frequency-division multiplexing (OFDM) PHY type.
        hrdsss = 5                                                                      '   High-rate DSSS (HRDSSS) PHY type
        erp = 6                                                                         '   Extended rate PHY (ERP) type.
        ht = 7                                                                          '   High throughput (HT) PHY type.
        vht = 8                                                                         '   Very high throughput (VHT) PHY type.
'        IHV_start   = 0x80000000
'        IHV_end     = 0xffffffff
    End Enum
'
    Private Type WLAN_RATE_SET
        uRateSetLength                                  As Long                         '   Length of the rate set in bytes.
        usRateSet(DOT11_RATE_SET_MAX_LENGTH - 1)        As Integer                      '   Array to store rate values with a maximum length of (DOT11_RATE_SET_MAX_LENGTH - 1) elements.
    End Type
'
    Private Type WLAN_AVAILABLE_NETWORK
        strProfileName(511)                             As Byte                         '   * 1: Profile name of the available network, stored as a byte array with a
'                                                                                       '           maximum length of 511 characters.
        dot11Ssid                                       As DOT11_SSID                   '   * 2: SSID of the available network, represented by the DOT11_SSID type.
        dot11BssType                                    As Long                         '   Type of Basic Service Set (BSS) of the network (e.g., infrastructure, independent).
        uNumberOfBssids                                 As Long                         '   * 7: Number of BSSIDs (MAC addresses) for the available network.
        bNetworkConnectable                             As Long                         '   Flag indicating if the network is currently connectable.
        wlanNotConnectableReason                        As Long                         '   Reason code for why the network is not connectable.
        uNumberOfPhyTypes                               As Long                         '   * 8: Number of supported PHY types for the network.
        dot11PhyTypes(WLAN_MAX_PHY_TYPE_NUMBER - 1)     As Long                         '   * 9: Array of supported PHY types (e.g., OFDM, HT) with a maximum length defined
'                                                                                       '           by WLAN_MAX_PHY_TYPE_NUMBER.
        bMorePhyTypes                                   As Long                         '   Flag indicating if there are additional PHY types not included in the array.
        wlanSignalQuality                               As Long                         '   * 3: Signal quality of the network.
        bSecurityEnabled                                As Long                         '   Flag indicating if the network has security enabled.
        dot11DefaultAuthAlgorithm                       As Long                         '   * 10: Default authentication algorithm used by the network (e.g., WPA, WPA2, etc).
        dot11DefaultCipherAlgorithm                     As Long                         '   * 11: Default cipher algorithm used by the network (e.g., TKIP, AES. etc).
        dwFlags                                         As Long                         '   * 6: Additional flags providing information about the network (e.g., hidden network).
        dwReserved                                      As Long                         '   Reserved field for future use.
    End Type
'
    Private Type WLAN_AVAILABLE_NETWORK_LIST                                            '   List of available WLAN networks
        dwNumberOfItems                                 As Long                         '   Number of items in the list
        dwIndex                                         As Long                         '   Index of the list
'        Network                                         As WLAN_AVAILABLE_NETWORK
    End Type
'
    Private Type WLAN_INTERFACE_INFO_LIST
        dwNumberOfItems                                 As Long                         '   The number of WLAN interfaces in the list.
        dwIndex                                         As Long                         '   The index of the current WLAN interface (used for enumeration).
        InterfaceInfo                                   As WLAN_INTERFACE_INFO          '   The WLAN_INTERFACE_INFO structure that holds information about the WLAN interface.
    End Type
'
    Private Type WLAN_BSS_ENTRY
        dot11Ssid                                       As DOT11_SSID                   '   SSID of the BSS
        uPhyId                                          As Long                         '   PHY ID
        dot11Bssid(0 To 5)                              As Byte                         '   BSSID (MAC address)
        dot11BssType                                    As DOT11_BSS_TYPE               '   Type of BSS (infrastructure, independent, or any)
        dot11BssPhyType                                 As DOT11_PHY_TYPE               '   PHY type of the BSS
        lRssi                                           As Long                         '   Received Signal Strength Indicator (RSSI) value
        uLinkQuality                                    As Long                         '   Link quality value
        bInRegDomain                                    As Boolean                      '   Is the BSS in a regulatory domain?
        usBeaconPeriod                                  As Integer                      '   Beacon period of the BSS
        ullTimestamp                                    As Double                       '   Timestamp
        ullHostTimestamp                                As Double                       '   Host timestamp
        usCapabilityInformation                         As Integer                      '   Capability information of the BSS
        ulChCenterFrequency                             As Long                         '   Channel center frequency of the BSS
        wlanRateSet                                     As WLAN_RATE_SET                '   WLAN rate set of the BSS
        ulIeOffset                                      As Long                         '   Information element offset
        ulIeSize                                        As Long                         '   Information element size
    End Type
'
    Private Type WLAN_BSS_LIST                                                          '   List of WLAN_BSS_ENTRY
        dwTotalSize                                     As Long                         '   Total size of the list
        dwNumberOfItems                                 As Long                         '   Number of items in the list
        wlanBssEntries(1)                               As WLAN_BSS_ENTRY               '   Fixed-size array of WLAN_BSS_ENTRY
    End Type
'
    Declare PtrSafe Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" (Destination As Any, _
            Source As Any, ByVal length As Long)
'
    Declare PtrSafe Function WlanOpenHandle Lib "wlanapi.dll" (ByVal dwClientVersion As Long, _
            ByVal pdwReserved As LongPtr, ByRef pdwNegotiaitedVersion As Long, _
            ByRef phClientHandle As LongPtr) As Long
'
    Declare PtrSafe Function WlanCloseHandle Lib "wlanapi.dll" (ByVal hClientHandle As LongPtr, _
            Optional ByVal pReserved As LongPtr) As Long
'
    Declare PtrSafe Function WlanEnumInterfaces Lib "wlanapi.dll" (ByVal hClientHandle As LongPtr, _
            ByVal pReserved As LongPtr, ByRef ppInterfaceList As LongPtr) As Long
'
    Declare PtrSafe Function WlanScan Lib "wlanapi.dll" (ByVal hClientHandle As LongPtr, _
            ByRef pInterfaceGuid As GUID, Optional ByVal pDot11Ssid As LongPtr, _
            Optional ByVal pIeData As LongPtr, Optional ByVal pReserved As LongPtr) As Long
'
    Declare PtrSafe Function WlanGetAvailableNetworkList Lib "wlanapi.dll" ( _
            ByVal hClientHandle As LongPtr, ByRef pInterfaceGuid As GUID, ByVal dwFlags As Long, _
            ByVal pReserved As LongPtr, ByRef ppAvailableNetworkList As LongPtr) As Long
'
    Private Declare PtrSafe Function WlanGetNetworkBssList Lib "wlanapi.dll" (ByVal hClientHandle As LongPtr, _
            ByRef pInterfaceGuid As Any, ByVal pDot11Ssid As Any, ByVal dot11BssType As Long, _
            ByVal bSecurityEnabled As Long, ByVal pReserved As Any, ByRef ppWlanBssList As LongPtr) As Long
'
    Declare PtrSafe Sub WlanFreeMemory Lib "wlanapi.dll" (ByVal pMemory As LongPtr)
                

Sub GetWiFiConnetionsDetectedV2_CombinedV1()
'
    Dim Arrayrow                As Long
    Dim EnumInterfacesList      As Long
    Dim i                       As Long
    Dim lngAvailable            As Long
    Dim lngReturn               As Long
    Dim lngStartUdtNetwork      As Long
    Dim lngStartUdtWLANbss      As Long
    Dim NetworkBssList          As Long
    Dim NumberOfItems           As Long
    Dim OpenHandleClientHandle  As Long
    Dim OpenHandleClientVersion As Long
    Dim MacAddress              As String
    Dim PhyTypesString          As String
    Dim strProfile              As String
    Dim strSSID                 As String
    Dim HeaderArray             As Variant
    Dim resultArray()           As Variant
    Dim udtNetwork              As WLAN_AVAILABLE_NETWORK
    Dim udtAvailableList        As WLAN_AVAILABLE_NETWORK_LIST
    Dim udtWLANbss              As WLAN_BSS_ENTRY
    Dim wlanBssList             As WLAN_BSS_LIST
    Dim InterfaceInfoList       As WLAN_INTERFACE_INFO_LIST
'
    Application.ScreenUpdating = False
'
    HeaderArray = Array("Profile", "SSID", "Signal Quality", "Connected", "Number of BSSids", _
            "Number of PHY Types", "PHY Types", "Default Auth Algorithm", "Default Cypher Algorithm", _
            "SSID", "PhyId", "Bssid", "BssType", "Rssi", "LinkQuality", "InRegDomain", "BeaconPeriod", "Timestamp", _
            "HostTimestamp", "CapabilityInformation", "ChCenterFrequency", "IeOffset", "IeSize", "wlanRateSet")
'
    Range("A1").CurrentRegion.ClearContents                                                 ' Clear any existing data
'
' Get a Handle
    lngReturn = WlanOpenHandle(2&, 0&, OpenHandleClientVersion, OpenHandleClientHandle)
'
    If lngReturn = 0 Then                                                                   ' If WLAN handle was successful obtained then ...
        lngReturn = WlanEnumInterfaces(ByVal OpenHandleClientHandle, 0&, EnumInterfacesList) '   Enumerate the WLAN Interfaces, (Note: this code only looks at first interface)
        CopyMemory InterfaceInfoList, ByVal EnumInterfacesList, Len(InterfaceInfoList)      '   Copy the enumerated interface information to InterfaceInfoList
'
        lngReturn = WlanScan(OpenHandleClientHandle, InterfaceInfoList.InterfaceInfo.interfaceGuid) '   Refresh the available WIFI networks list
'
        lngReturn = WlanGetAvailableNetworkList(OpenHandleClientHandle, _
                InterfaceInfoList.InterfaceInfo.interfaceGuid, 2&, 0&, lngAvailable)        '   Get network list
        CopyMemory udtAvailableList, ByVal lngAvailable, LenB(udtAvailableList)             '   Copy the network list information to udtAvailableList
        lngStartUdtNetwork = lngAvailable + 8                                               '   Set the starting memory address for the available networks data.
'
        lngReturn = WlanGetNetworkBssList(OpenHandleClientHandle, InterfaceInfoList.InterfaceInfo.interfaceGuid, _
                0&, 1, False, ByVal 0&, NetworkBssList)                                     '   Get BSS List
        CopyMemory wlanBssList, ByVal NetworkBssList, LenB(wlanBssList)                     '   Copy the BSS list information to wlanBssList
        lngStartUdtWLANbss = NetworkBssList + 8                                             '   Set the starting memory address for the BSS list data.
'
' ********************************
' * Scrape the data that we want *
' ********************************
'
        ReDim resultArray(1 To 100, 1 To UBound(HeaderArray, 1) + 1)                        '   Establish the dimensions to use for resultArray, we can correct them later
'
        Do                                                                                  '   Loop through the available WIFI networks found
            Arrayrow = Arrayrow + 1                                                         '       Increment Arrayrow
'
' Populate the Available network structure
            CopyMemory udtNetwork, ByVal lngStartUdtNetwork, Len(udtNetwork)                '       Copy the network WLAN_AVAILABLE_NETWORK data to udtNetwork
            CopyMemory udtWLANbss, ByVal lngStartUdtWLANbss, Len(udtWLANbss)                '       Copy the network WLAN_BSS_ENTRY data to udtWLANbss
'
' Save the Data from WLAN_AVAILABLE_NETWORK
            For i = 0 To UBound(udtNetwork.strProfileName)                                  '       Loop through the bytes of strProfileName
                strProfile = strProfile & Chr(udtNetwork.strProfileName(i))                 '           Save the formatted strProfileName byte to strProfile
            Next                                                                            '       Loop back
'
            strProfile = StrConv(strProfile, vbFromUnicode)                                 '       Strip the bs characters from strProfile
'
            strProfile = Left$(strProfile, InStr(strProfile, Chr(0)) - 1)                   '       Strip rest of bs characters from strProfile
'
            resultArray(Arrayrow, 1) = strProfile                                           '       Save strProfile to resultArray
            strProfile = ""                                                                 '       Clear strProfile
'
            strSSID = Replace(StrConv(udtNetwork.dot11Ssid.ucSSID, vbUnicode), Chr(0), "")  '       Format dot11Ssid.ucSSID & save it to strSSID
'
            If Len(strSSID) < 1 Then strSSID = "Unnamed"                                    '       If strSSID = "" then set strSSID = "Unnamed"
'
            resultArray(Arrayrow, 2) = strSSID                                              '       Save strSSID to resultArray
            resultArray(Arrayrow, 3) = udtNetwork.wlanSignalQuality                         '       Save wlanSignalQuality to resultArray
'
            resultArray(Arrayrow, 4) = udtNetwork.dwFlags                                   '       Save dwFlags to resultArray
            resultArray(Arrayrow, 5) = udtNetwork.uNumberOfBssids                           '       Save uNumberOfBssids to resultArray
            resultArray(Arrayrow, 6) = udtNetwork.uNumberOfPhyTypes                         '       Save uNumberOfPhyTypes to resultArray
'
            For i = 0 To UBound(udtNetwork.dot11PhyTypes)                                   '       Loop through the dot11PhyTypes
                If PhyTypesString <> "" Then                                                '           If this is NOT the first dot11PhyType then ...
                    PhyTypesString = PhyTypesString & "," & udtNetwork.dot11PhyTypes(i)     '               Append the value to PhyTypesString
                Else                                                                        '           Else ...
                    PhyTypesString = udtNetwork.dot11PhyTypes(i)                            '               Save value to PhyTypesString
                End If
            Next                                                                            '       Loop back
'
            PhyTypesString = Replace(PhyTypesString, ",0", "")                              '       Delete the excess zeros from PhyTypesString
'
            resultArray(Arrayrow, 7) = PhyTypesString                                       '       Save PhyTypesString to resultArray
            PhyTypesString = ""                                                             '       Clear PhyTypesString
'
            Select Case udtNetwork.dot11DefaultAuthAlgorithm                                '       Get dot11DefaultAuthAlgorithm and save the equated value to resultArray
                Case 1: resultArray(Arrayrow, 8) = "Open"
                Case 2: resultArray(Arrayrow, 8) = "WEP"
                Case 3: resultArray(Arrayrow, 8) = "WPA"
                Case 4: resultArray(Arrayrow, 8) = "WPA_PSK"
                Case 6: resultArray(Arrayrow, 8) = "WPA2"
                Case 7: resultArray(Arrayrow, 8) = "WPA2_PSK"
                Case 8: resultArray(Arrayrow, 8) = "WPA3"
                Case 9: resultArray(Arrayrow, 8) = "WPA3_SAE"
                Case 10: resultArray(Arrayrow, 8) = "OWE"
                Case 11: resultArray(Arrayrow, 8) = "WPA3_ENT"
            End Select
'
            resultArray(Arrayrow, 9) = udtNetwork.dot11DefaultCipherAlgorithm               '       Save dot11DefaultCipherAlgorithm to resultArray
'
' Save the Data from WLAN_BSS_ENTRY
            strSSID = Replace(StrConv(udtWLANbss.dot11Ssid.ucSSID, vbUnicode), Chr(0), "")  '       Format dot11Ssid.ucSSID & save it to strSSID
'
            If Len(strSSID) < 1 Then strSSID = "Unnamed"                                    '       If strSSID = "" then set strSSID = "Unnamed"
'
            resultArray(Arrayrow, 10) = strSSID                                             '       Save strSSID to resultArray
            resultArray(Arrayrow, 11) = udtWLANbss.uPhyId                                   '       Save uPhyId to resultArray
'
            For i = 0 To 5                                                                  '       Loop through the 6 bytes of the BSSID (MAC ADDRESS)
                MacAddress = MacAddress & Right$("0" & Hex(udtWLANbss.dot11Bssid(i)), 2) & ":"  '       Save the byte to MacAddress
            Next                                                                            '       Loop back
'
            MacAddress = Left$(MacAddress, Len(MacAddress) - 1)                             '
'
            resultArray(Arrayrow, 12) = MacAddress                                          '       Save MacAddress to resultArray
            MacAddress = ""                                                                 '       Clear MacAddress



            resultArray(Arrayrow, 13) = udtWLANbss.dot11BssType                             '       Save dot11BssType to resultArray
            resultArray(Arrayrow, 14) = udtWLANbss.lRssi                                    '       Save lRssi to resultArray
            resultArray(Arrayrow, 15) = udtWLANbss.uLinkQuality                             '       Save uLinkQuality to resultArray
            resultArray(Arrayrow, 16) = udtWLANbss.bInRegDomain                             '       Save bInRegDomain to resultArray
            resultArray(Arrayrow, 17) = udtWLANbss.usBeaconPeriod                           '       Save usBeaconPeriod to resultArray
            resultArray(Arrayrow, 18) = udtWLANbss.ullTimestamp                             '       Save ullTimestamp to resultArray
            resultArray(Arrayrow, 19) = udtWLANbss.ullHostTimestamp                         '       Save ullHostTimestamp to resultArray
            resultArray(Arrayrow, 20) = udtWLANbss.usCapabilityInformation                  '       Save usCapabilityInformation to resultArray
            resultArray(Arrayrow, 21) = udtWLANbss.ulChCenterFrequency                      '       Save ulChCenterFrequency to resultArray
            resultArray(Arrayrow, 22) = udtWLANbss.ulIeOffset                               '       Save ulIeOffset to resultArray
            resultArray(Arrayrow, 23) = udtWLANbss.ulIeSize                                 '       Save ulIeSize to resultArray
'            resultArray(Arrayrow, 24) = udtWLANbss.wlanRateSet                             ' Compile error on this line
'
            NumberOfItems = NumberOfItems + 1                                               '       Increment NumberOfItems
            lngStartUdtNetwork = lngStartUdtNetwork + Len(udtNetwork)                       '       Advance the lngStartUdtNetwork memory address
            lngStartUdtWLANbss = lngStartUdtWLANbss + Len(udtWLANbss)                       '       Advance the lngStartUdtWLANbss memory address
        Loop Until NumberOfItems = udtAvailableList.dwNumberOfItems                         '   Loop back if more WIFI networks are available
'
        Range("A1").Resize(, UBound(HeaderArray, 1) + 1) = HeaderArray                      '   Display HeaderArray to the sheet
'
        resultArray = ReDimPreserve(resultArray, Arrayrow, UBound(HeaderArray, 1) + 1)      '   Resize resultArray to actual dimensions that we ended up needing
'
        Range("A2").Resize(UBound(resultArray, 1), UBound(resultArray, 2)) = resultArray    '   Display resultArray to the sheet
'
        With Range("C2:I" & Range("I" & Rows.Count).End(xlUp).Row)                          '   Center the data in the cells in columns C:I
            .HorizontalAlignment = xlCenter
              .VerticalAlignment = xlCenter
        End With
'
        ActiveSheet.UsedRange.EntireColumn.AutoFit                                          '   Autofit the widths of the used columns in the sheet
    End If
'
    WlanFreeMemory EnumInterfacesList
    WlanFreeMemory lngAvailable
    WlanFreeMemory NetworkBssList
    WlanCloseHandle OpenHandleClientHandle                                                  ' Release handle
'
    Application.ScreenUpdating = True                                                       ' Turn ScreenUpdating back on
End Sub


Public Function ReDimPreserve(ArrayNameToResize, NewRowUbound, NewColumnUbound)
'
' Code inspired by Control Freak
'
' Preserve Original data & LBounds & Redim both dimensions for a 2D array
'
' example usage of the function:
' ResizedArrayName = ReDimPreserve(ArrayNameToResize,NewRowSize,NewColumnSize)
' ie.
' InputArray = ReDimPreserve(InputArray,10,20)
'
' This function will keep the LBounds (Lower Bounds) of the original array.
'
    Dim NewColumn                   As Long, NewRow                      As Long
    Dim OldColumnLbound             As Long, OldRowLbound                As Long
    Dim OldColumnUbound             As Long, OldRowUbound                As Long
    Dim NewResizedArray()           As Variant
'
    ReDimPreserve = False
'
    If IsArray(ArrayNameToResize) Then                                                                      ' If the variable is an array then ...
           OldRowLbound = LBound(ArrayNameToResize, 1)                                                      '   Save the original row Lbound to OldRowLbound
        OldColumnLbound = LBound(ArrayNameToResize, 2)                                                      '   Save the original column Lbound to OldColumnLbound
'
        ReDim NewResizedArray(OldRowLbound To NewRowUbound, OldColumnLbound To NewColumnUbound)             '   Create a New 2D Array with same Lbounds as the original array
'
        OldRowUbound = UBound(ArrayNameToResize, 1)                                                         '   Save row Ubound of original array
        OldColumnUbound = UBound(ArrayNameToResize, 2)                                                      '   Save column Ubound of original array
'
        For NewRow = OldRowLbound To NewRowUbound                                                           '   Loop through rows of original array
            For NewColumn = OldColumnLbound To NewColumnUbound                                              '       Loop through columns of original array
                If OldRowUbound >= NewRow And OldColumnUbound >= NewColumn Then                             '           If more data to copy then ...
                    NewResizedArray(NewRow, NewColumn) = ArrayNameToResize(NewRow, NewColumn)               '               Append rows/columns to NewResizedArray
                End If
            Next                                                                                            '       Loop back
        Next                                                                                                '   Loop back
'
        Erase ArrayNameToResize                                                                             '   Free up the memory the Original array was taking
'
        If IsArray(NewResizedArray) Then ReDimPreserve = NewResizedArray
    End If
End Function

 

[Jaafar Tribak]

1) lines in the 'bas_API' module with the '^' are not liked by excel. I had to remove all of those '^' in the lines that they were found in.
2) a few lines in the 'UserForm1' module produced errors RTE 9

1) Oops!
^ that sympbol coerces the litteral value 8 or variable into a LongLong (8bits) just like ClngLng does or ClngPtr ... I used that when editing\debugging the code because I have office x64bit and forgot to remove it ... Just removing it should prevent the compile error and the code should still work accross all excel versions bitneswise without needing to change the variables or api declarations.

2) For debugging purposes, try adding the line below right at the end of the GetInfo function that is located in the bas_API module.
Debug.Print UBound(Split((Msg), vbCrLf))

Load the userform and see the vbe immediate window output ... Do you get 7 before the RTE 9?

 

[Jaafar Tribak]

Ok. I think I found the bug that produces the runtime error. It was in the GetInfo function. Now bug fixed.

Thanks johnnyL for reviewing the code and discovering the two bugs.

File Update:
WifiScanner.xlsm


Below, is the entire vbaproject correct code after having fixed the bugs:

1- API worker code in the bas_API Standard Module:

Option Explicit

'code adapted to vba from: (Credits for the original code go to 'J.A. Coutts' @ VBForums)
'https://www.vbforums.com/showthread.php?881991-Simplified-WiFi-Scan&p=5442943&viewfull=1#post5442943

#If VBA7 Then
    Private Declare PtrSafe Function WlanOpenHandle Lib "wlanapi.dll" (ByVal dwClientVersion As Long, ByVal pdwReserved As LongPtr, ByRef pdwNegotiaitedVersion As Long, ByRef phClientHandle As LongPtr) As Long
    Private Declare PtrSafe Function WlanCloseHandle Lib "wlanapi.dll" (ByVal hClientHandle As LongPtr, ByVal pdwReserved As LongPtr) As Long
    Private Declare PtrSafe Function WlanEnumInterfaces Lib "wlanapi.dll" (ByVal hClientHandle As LongPtr, ByVal pReserved As LongPtr, ppInterfaceList As LongPtr) As Long
    Private Declare PtrSafe Function WlanGetAvailableNetworkList Lib "wlanapi.dll" (ByVal hClientHandle As LongPtr, pInterfaceGuid As GUID, ByVal dwFlags As Long, ByVal pReserved As LongPtr, ppAvailableNetworkList As LongPtr) As Long
    Private Declare PtrSafe Function WlanConnect Lib "wlanapi.dll" (ByVal hClientHandle As LongPtr, pInterfaceGuid As GUID, pConnectionParameters As WLAN_CONNECTION_PARAMETERS, ByVal reserved As LongPtr) As Long
    Private Declare PtrSafe Function WlanScan Lib "wlanapi.dll" (ByVal hClientHandle As LongPtr, pInterfaceGuid As GUID, pDot11Ssid As LongPtr, pIeData As LongPtr, reserved As LongPtr) As Long
    Private Declare PtrSafe Function WlanDisconnect Lib "wlanapi.dll" (ByVal hClientHandle As LongPtr, pInterfaceGuid As GUID, ByVal pReserved As LongPtr) As Long
    Private Declare PtrSafe Function WlanGetNetworkBssList Lib "wlanapi.dll" (ByVal hClientHandle As LongPtr, pInterfaceGui As GUID, ByVal pDot11Ssid As Long, ByVal dot11BssType As LongPtr, ByVal bSecurityEnabled As LongPtr, ByVal pReserved As LongPtr, ppWlanBssList As LongPtr) As Long
    Private Declare PtrSafe Sub WlanFreeMemory Lib "wlanapi.dll" (ByVal pMemory As LongPtr)
    Private Declare PtrSafe Sub CopyMemory Lib "kernel32.dll" Alias "RtlMoveMemory" (Destination As Any, Source As Any, ByVal Length As LongPtr)
    Private Declare PtrSafe Sub Sleep Lib "kernel32.dll" (ByVal dwMilliseconds As Long)
    Private Declare PtrSafe Function FileTimeToSystemTime Lib "kernel32" (lpFileTime As FILETIME, lpSystemTime As SYSTEMTIME) As Long
    Private Declare PtrSafe Function FileTimeToLocalFileTime Lib "kernel32" (lpFileTime As FILETIME, lpLocalFileTime As FILETIME) As Long
#Else
    Private Enum LongPtr
        [_]
    End Enum
    Private Declare Function WlanOpenHandle Lib "wlanapi.dll" (ByVal dwClientVersion As Long, ByVal pdwReserved As Long, ByRef pdwNegotiaitedVersion As Long, ByRef phClientHandle As Long) As Long
    Private Declare Function WlanCloseHandle Lib "wlanapi.dll" (ByVal hClientHandle As Long, ByVal pdwReserved As Long) As Long
    Private Declare Function WlanEnumInterfaces Lib "wlanapi.dll" (ByVal hClientHandle As Long, ByVal pReserved As Long, ppInterfaceList As Long) As Long
    Private Declare Function WlanGetAvailableNetworkList Lib "wlanapi.dll" (ByVal hClientHandle As Long, pInterfaceGuid As GUID, ByVal dwFlags As Long, ByVal pReserved As Long, ppAvailableNetworkList As Long) As Long
    Private Declare Function WlanConnect Lib "wlanapi.dll" (ByVal hClientHandle As Long, pInterfaceGuid As GUID, pConnectionParameters As WLAN_CONNECTION_PARAMETERS, ByVal reserved As Long) As Long
    Private Declare Function WlanScan Lib "wlanapi.dll" (ByVal hClientHandle As Long, pInterfaceGuid As GUID, pDot11Ssid As Long, pIeData As Long, reserved As Long) As Long
    Private Declare Function WlanDisconnect Lib "wlanapi.dll" (ByVal hClientHandle As Long, pInterfaceGuid As GUID, ByVal pReserved As Long) As Long
    Private Declare Function WlanGetNetworkBssList Lib "wlanapi.dll" (ByVal hClientHandle As Long, pInterfaceGui As GUID, ByVal pDot11Ssid As Long, ByVal dot11BssType As Long, ByVal bSecurityEnabled As Long, ByVal pReserved As Long, ppWlanBssList As Long) As Long
    Private Declare Sub WlanFreeMemory Lib "wlanapi.dll" (ByVal pMemory As Long)
    Private Declare Sub CopyMemory Lib "kernel32.dll" Alias "RtlMoveMemory" (Destination As Any, Source As Any, ByVal Length As Long)
    Private Declare Sub Sleep Lib "kernel32.dll" (ByVal dwMilliseconds As Long)
    Private Declare Function FileTimeToSystemTime Lib "kernel32" (lpFileTime As FILETIME, lpSystemTime As SYSTEMTIME) As Long
    Private Declare Function FileTimeToLocalFileTime Lib "kernel32" (lpFileTime As FILETIME, lpLocalFileTime As FILETIME) As Long
#End If

Private Type GUID
    data1 As Long
    data2 As Integer
    data3 As Integer
    data4(7) As Byte
End Type

Private Type WLAN_INTERFACE_INFO
    ifGuid As GUID
    InterfaceDescription(511) As Byte
    IsState As Long
End Type

Private Type DOT11_SSID
    uSSIDLength As Long
    ucSSID(31) As Byte
End Type

Private Type WLAN_RATE_SET
    uRateSetLength As Long
    usRateSet(125) As Integer
End Type

Private Type FILETIME
    dwLowDateTime As Long
    dwHighDateTime As Long
End Type

Private Type SYSTEMTIME
    wYear As Integer
    wMonth As Integer
    wDayOfWeek As Integer
    wDay As Integer
    wHour As Integer
    wMinute As Integer
    wSecond As Integer
    wMilliseconds As Integer
End Type

Private Type TIME_ZONE_INFORMATION
   Bias As Long
   StandardName(0 To 63) As Byte
   StandardDate As SYSTEMTIME
   StandardBias As Long
   DaylightName(0 To 63) As Byte
   DaylightDate As SYSTEMTIME
   DaylightBias As Long
End Type

Private Type WLAN_AVAILABLE_NETWORK
    strProfileName(511) As Byte
    dot11Ssid As DOT11_SSID
    dot11BssType As Long
    uNumberOfBssids As Long
    bNetworkConnectable As Long
    wlanNotConnectableReason As Long
    uNumberOfPhyTypes As Long
    dot11PhyTypes(7) As Long
    bMorePhyTypes As Long
    wlanSignalQuality As Long
    bSecurityEnabled As Long
    dot11DefaultAuthAlgorithm As Long
    dot11DefaultCipherAlgorithm As Long
    dwFlags As Long
    dwreserved As Long
End Type

Private Type AVAILABLE_NETWORK
    dot11Ssid As DOT11_SSID
    dot11BssType As Long
    uNumberOfBssids As Long
    bNetworkConnectable As Long
    wlanNotConnectableReason As Long
    uNumberOfPhyTypes As Long
    dot11PhyTypes(7) As Long
    bMorePhyTypes As Long
    wlanSignalQuality As Long
    bSecurityEnabled As Long
    dot11DefaultAuthAlgorithm As Long
    dot11DefaultCipherAlgorithm As Long
    dwFlags As Long
    dwreserved As Long
End Type

Private Type WLAN_BSS_ENTRY
    dot11Ssid As DOT11_SSID
    uPhyId As Long
    dot11Bssid(7) As Byte
    dot11BssType As DOT11_BSS_TYPE
    dot11BssPhyType As DOT11_PHY_TYPE
    lRssi As Long
    uLinkQuality As Long
    bInRegDomain As Long
    usBeaconPeriod As Long
    ullTimestamp As FILETIME
    ullHostTimestamp As FILETIME
    usCapabilityInformation As Long
    ulChCenterFrequency As Long
    wlanRateSet As WLAN_RATE_SET
    ulIeOffset As Long
    ulIeSize As Long
End Type

Private Type WLAN_INTERFACE_INFO_LIST
    dwNumberofItems As Long
    dwIndex As Long
    InterfaceInfo As WLAN_INTERFACE_INFO
End Type

Private Type WLAN_AVAILABLE_NETWORK_LIST
    dwNumberofItems As Long
    dwIndex As Long
    Network As WLAN_AVAILABLE_NETWORK
End Type

Private Type WLAN_CONNECTION_PARAMETERS
    ConnectionMode As Long
    Profile As LongPtr
    pDot11Ssid As LongPtr
    pDesiredBssidList As LongPtr
    dot11BssType As Long
    dwFlags As Long
End Type

Private Type WLAN_BSS_LIST
    dwTotalSize As Long
    dwNumberofItems As Long
    wlanBssEntries As Long
End Type

Public Type BSS_INFO
    uPhyId As Long
    MAC As String
    dot11BssType As DOT11_BSS_TYPE
    dot11BssPhyType As DOT11_PHY_TYPE
    lRssi  As Long
    uLinkQuality As Long
    ullHostTimestamp As String
    ullTimestamp As String
    ulChCenterFrequency As Currency
    uRateSetLength As Long
    ulIeOffset As Long
    ulIeSize  As Long
    usCapabilityInformation As Double
    bInRegDomain As Long
    usBeaconPeriod As Long
End Type

Private Enum DOT11_PHY_TYPE
    dot11_phy_type_unknown = 0
    dot11_phy_type_any = 0
    dot11_phy_type_fhss = 1
    dot11_phy_type_dsss = 2
    dot11_phy_type_irbaseband = 3
    dot11_phy_type_ofdm = 4
    dot11_phy_type_hrdsss = 5
    dot11_phy_type_erp = 6
    dot11_phy_type_ht = 7
    dot11_phy_type_IHV_start = &H80000000
    dot11_phy_type_IHV_end = &HFFFFFFFF
End Enum

Private Enum DOT11_BSS_TYPE
    dot11_BSS_type_infrastructure = 1
    dot11_BSS_type_independent = 2
    DOT11_BSS_TYPE_ANY = 3
End Enum

Private Enum DOT11_AUTH_ALGORITHM
    DOT11_AUTH_ALGO_80211_OPEN = 1
    DOT11_AUTH_ALGO_80211_SHARED_KEY = 2
    DOT11_AUTH_ALGO_WPA = 3
    DOT11_AUTH_ALGO_WPA_PSK = 4
    DOT11_AUTH_ALGO_WPA_NONE = 5
    DOT11_AUTH_ALGO_RSNA = 6
    DOT11_AUTH_ALGO_RSNA_PSK = 7
    DOT11_AUTH_ALGO_IHV_START = &H80000000
    DOT11_AUTH_ALGO_IHV_END = &HFFFFFFFF
End Enum

Private Enum DOT11_CIPHER_ALGORITHM
    DOT11_CIPHER_ALGO_NONE = &H0
    DOT11_CIPHER_ALGO_WEP40 = &H1
    DOT11_CIPHER_ALGO_TKIP = &H2
    DOT11_CIPHER_ALGO_CCMP = &H4
    DOT11_CIPHER_ALGO_WEP104 = &H5
    DOT11_CIPHER_ALGO_WPA_USE_GROUP = &H100
    DOT11_CIPHER_ALGO_RSN_USE_GROUP = &H100
    DOT11_CIPHER_ALGO_WEP = &H101
    DOT11_CIPHER_ALGO_IHV_START = &H80000000
    DOT11_CIPHER_ALGO_IHV_END = &HFFFFFFFF
End Enum

Private udtList As WLAN_INTERFACE_INFO_LIST
Private udtBSSList As WLAN_BSS_LIST
Private ConIndex As Long
Public lHandle As LongPtr
Private lVersion As Long
Private Connected As String
Private bBuffer() As Byte
Public lNumberOfnetworkItems As Long


Public Function GetBSS(ByVal SSID As String) As BSS_INFO  ' WLAN_BSS_ENTRY
    Dim lBSS As LongPtr
    Dim lRet As Long
    Dim sLen As Long
    Dim lStart As LongPtr
    Dim lCount As Long
    Dim sSSID As String
    Dim sMAC As String
    Dim sTime As String
    Dim bTmp() As Byte
    Dim ListArray(10) As String
    Dim BSSInfo() As Byte
    Dim udtBSS As WLAN_BSS_ENTRY
    Dim tINFO As BSS_INFO

    If lHandle = 0 Then Exit Function
    lRet = WlanGetNetworkBssList(lHandle, udtList.InterfaceInfo.ifGuid, ByVal 0&, DOT11_BSS_TYPE.DOT11_BSS_TYPE_ANY, 0, 0, lBSS)
    CopyMemory udtBSSList, ByVal lBSS, Len(udtBSSList)
    If lRet Then
        Debug.Print "Error: "; CStr(lRet)
        MsgBox "No BSS Info Available!"
    Else
        lStart = lBSS + 8
        lCount = 0
        Do
            CopyMemory udtBSS, ByVal lStart, Len(udtBSS)
            sLen = udtBSS.dot11Ssid.uSSIDLength
             If sLen = 0 Then
                sSSID = "(Unknown)"
            Else
                ReDim bTmp(sLen - 1)
                CopyMemory bTmp(0), udtBSS.dot11Ssid.ucSSID(0), sLen
                sSSID = ByteToStr(bTmp)
            End If
            If UCase(RTrim(SSID)) = UCase(RTrim(sSSID)) Then
                sMAC = MACtoString(udtBSS.dot11Bssid)
                With tINFO
                    .uPhyId = udtBSS.uPhyId
                    .MAC = sMAC
                    .dot11BssType = udtBSS.dot11BssType
                    .dot11BssPhyType = udtBSS.dot11BssPhyType
                    .lRssi = udtBSS.lRssi
                    .uLinkQuality = udtBSS.uLinkQuality
                    .ullHostTimestamp = TimeToString(udtBSS.ullHostTimestamp)
                    .ullTimestamp = TimeToString(udtBSS.ullTimestamp)
                    .ulChCenterFrequency = Round(udtBSS.ulChCenterFrequency / 1000000, 2)
                    .uRateSetLength = udtBSS.wlanRateSet.uRateSetLength
                    .ulIeOffset = udtBSS.ulIeOffset
                    .ulIeSize = udtBSS.ulIeSize
                    .usCapabilityInformation = udtBSS.usCapabilityInformation
                    .bInRegDomain = udtBSS.bInRegDomain
                    .usBeaconPeriod = udtBSS.usBeaconPeriod
                End With
                GetBSS = tINFO
                Exit Do
            End If
            lCount = lCount + 1
            lStart = lStart + Len(udtBSS)
        Loop Until lCount = udtBSSList.dwNumberofItems
        WlanFreeMemory lBSS
    End If
End Function

Public Function GetWifiAdapterName() As String
    Dim lRet As Long, lList As LongPtr
    If lHandle Then
        lRet = WlanScan(lHandle, udtList.InterfaceInfo.ifGuid, ByVal 0&, ByVal 0&, ByVal 0&)
        Call Wait(4)
    Else
        lRet = WlanOpenHandle(2&, 0&, lVersion, lHandle)
        'NOTE: This code currently only processes the first wireless adapter
        lRet = WlanEnumInterfaces(ByVal lHandle, 0&, lList)
        Call CopyMemory(udtList, ByVal lList, LenB(udtList))
    End If
    GetWifiAdapterName = ByteToStr2(udtList.InterfaceInfo.InterfaceDescription)
End Function

Public Function GetNetWorksNames() As String()
    Dim lRet As Long
    Dim lList As LongPtr
    Dim lAvailable As LongPtr
    Dim lStart As LongPtr
    Dim lCount As Long
    Dim sLen As Long
    Dim bSSID() As Byte
    Dim sSSID As String
    Dim udtAvailableList As WLAN_AVAILABLE_NETWORK_LIST
    Dim udtNetwork As WLAN_AVAILABLE_NETWORK
    Dim Network As AVAILABLE_NETWORK
    Dim lPtr As Long
    Dim sTmp() As String
 
    ConIndex = -1
    ReDim bBuffer(0)
    If lHandle Then
        lRet = WlanScan(lHandle, udtList.InterfaceInfo.ifGuid, ByVal 0&, ByVal 0&, ByVal 0&)
        'Wait for scan to finish (2 seconds)
        Call Wait(4)
    Else 'Get adapter handle and find WLAN interfaces
        lRet = WlanOpenHandle(2&, 0&, lVersion, lHandle)
        'NOTE: This code currently only processes the first wireless adapter
        lRet = WlanEnumInterfaces(ByVal lHandle, 0&, lList)
        CopyMemory udtList, ByVal lList, LenB(udtList)
'        Debug.Print udtList.dwNumberofItems, "WiFi Adapter found!"
    End If
    If udtList.dwNumberofItems > 0 Then
        lRet = WlanGetAvailableNetworkList(lHandle, udtList.InterfaceInfo.ifGuid, 2&, 0&, lAvailable)
        CopyMemory udtAvailableList, ByVal lAvailable, LenB(udtAvailableList)
        lCount = 0
        lStart = lAvailable + 8
        ReDim bBuffer(Len(Network) * udtAvailableList.dwNumberofItems - 1)
        Do 'Create new abbreviated buffer
            CopyMemory udtNetwork, ByVal lStart, Len(udtNetwork)
            lCount = lCount + 1
            lStart = lStart + Len(udtNetwork)
            CopyMemory bBuffer(lPtr), udtNetwork.dot11Ssid.uSSIDLength, Len(Network)
            lPtr = lPtr + Len(Network)
        Loop Until lCount = udtAvailableList.dwNumberofItems
        WlanFreeMemory lAvailable
        WlanFreeMemory lList
        'Create new list from new buffer
        lStart = VarPtr(bBuffer(0))
        lCount = 0
        Do
            CopyMemory Network, ByVal lStart, Len(Network)
            sLen = Network.dot11Ssid.uSSIDLength
            If sLen = 0 Then
                sSSID = "(Unknown)"
            Else
                ReDim bSSID(sLen - 1)
                CopyMemory bSSID(0), Network.dot11Ssid.ucSSID(0), sLen
                sSSID = ByteToStr(bSSID)
            End If
            sSSID = Left$(sSSID & Space$(25), 25)
            ReDim Preserve sTmp(lCount)
            sTmp(lCount) = sSSID
            If (Network.dwFlags And 1) = 1 Then
                ConIndex = lCount
            End If
            lCount = lCount + 1
            lStart = lStart + Len(Network)
        Loop Until lCount = udtAvailableList.dwNumberofItems
        GetNetWorksNames = sTmp
    Else
        MsgBox "No Wireless Adapters Found."
    End If
End Function

Public Function GetInfo(ByVal Index As Long) As String()
    Dim Network As AVAILABLE_NETWORK
    Dim lStart As LongPtr, sLen As Long, bSSID() As Byte
    Dim sSSID As String, lPtr As Long, Msg As String
 
    lStart = VarPtr(bBuffer(0)) + Index * Len(Network)
    CopyMemory Network, ByVal lStart, Len(Network)
    sLen = Network.dot11Ssid.uSSIDLength
    If sLen = 0 Then
        sSSID = "(Unknown)"
    Else
        ReDim bSSID(sLen - 1)
        CopyMemory bSSID(0), Network.dot11Ssid.ucSSID(0), sLen
        sSSID = ByteToStr(bSSID)
    End If
    If Network.dwFlags And 1 Then
        Msg = Msg & "TRUE"  ' Connected
    Else
        Msg = Msg & "FALSE"  'Disconnected
    End If
    Select Case Network.dot11BssType
        Case DOT11_BSS_TYPE.dot11_BSS_type_infrastructure
            Msg = Msg & vbCrLf & "BSS: Infrastructure"
        Case DOT11_BSS_TYPE.dot11_BSS_type_independent
            Msg = Msg & vbCrLf & "BSS: Peer to Peer"
    End Select
    If Network.bNetworkConnectable <> 0 Then
        Msg = Msg & vbCrLf & "TRUE"  'Connectable
    Else
        Msg = Msg & vbCrLf & "FALSE" 'Not Connectable
    End If
    For lPtr = 0 To UBound(Network.dot11PhyTypes)
        Select Case Network.dot11PhyTypes(lPtr)
            Case DOT11_PHY_TYPE.dot11_phy_type_ht
                Msg = Msg & vbCrLf & "802.11n"
            Case DOT11_PHY_TYPE.dot11_phy_type_erp
                Msg = Msg & vbCrLf & "802.11g"
            Case DOT11_PHY_TYPE.dot11_phy_type_ofdm
                Msg = Msg & vbCrLf & "802.11a"
        End Select
    Next lPtr
    If Network.bSecurityEnabled Then
        Msg = Msg & vbCrLf & "TRUE"   'Security Enabled
    Else
        Msg = Msg & vbCrLf & "FALSE"  'Security Disabled
    End If
    Select Case Network.dot11DefaultAuthAlgorithm
        Case DOT11_AUTH_ALGORITHM.DOT11_AUTH_ALGO_80211_OPEN
            Msg = Msg & vbCrLf & "Auth Algorithm: Open"
        Case DOT11_AUTH_ALGORITHM.DOT11_AUTH_ALGO_80211_SHARED_KEY
            Msg = Msg & vbCrLf & "Auth Algorithm: Shared Key"
        Case DOT11_AUTH_ALGORITHM.DOT11_AUTH_ALGO_WPA
            Msg = Msg & vbCrLf & "Auth Algorithm: WPA"
        Case DOT11_AUTH_ALGORITHM.DOT11_AUTH_ALGO_RSNA
            Msg = Msg & vbCrLf & "Auth Algorithm: RSNA"
        Case DOT11_AUTH_ALGORITHM.DOT11_AUTH_ALGO_RSNA_PSK
            Msg = Msg & vbCrLf & "Auth Algorithm: RSNA with Pre-shared Keys"
        Case DOT11_AUTH_ALGORITHM.DOT11_AUTH_ALGO_WPA_PSK
            Msg = Msg & vbCrLf & "Auth Algorithm: WPA with Pre-shared Keys"
        Case DOT11_AUTH_ALGORITHM.DOT11_AUTH_ALGO_80211_SHARED_KEY
            Msg = Msg & vbCrLf & "Auth Algorithm: WEP"
    End Select
    Select Case Network.dot11DefaultCipherAlgorithm
        Case DOT11_CIPHER_ALGORITHM.DOT11_CIPHER_ALGO_CCMP
            Msg = Msg & vbCrLf & "Cypher Algorithm: AES - CCMP"
        Case DOT11_CIPHER_ALGORITHM.DOT11_CIPHER_ALGO_NONE
            Msg = Msg & vbCrLf & "Cypher Algorithm: None"
        Case DOT11_CIPHER_ALGORITHM.DOT11_CIPHER_ALGO_RSN_USE_GROUP
            Msg = Msg & vbCrLf & "Cypher Algorithm: RSN - Use Group Key"
        Case DOT11_CIPHER_ALGORITHM.DOT11_CIPHER_ALGO_TKIP
            Msg = Msg & vbCrLf & "Cypher Algorithm: TKIP"
        Case DOT11_CIPHER_ALGORITHM.DOT11_CIPHER_ALGO_WEP
            Msg = Msg & vbCrLf & "Cypher Algorithm: WEP"
        Case DOT11_CIPHER_ALGORITHM.DOT11_CIPHER_ALGO_WEP104
            Msg = Msg & vbCrLf & "Cypher Algorithm: WEP - 104 Bit Key"
        Case DOT11_CIPHER_ALGORITHM.DOT11_CIPHER_ALGO_WEP40
            Msg = Msg & vbCrLf & "Cypher Algorithm: WEP - 40 Bit Key"
        Case DOT11_CIPHER_ALGORITHM.DOT11_CIPHER_ALGO_WPA_USE_GROUP
            Msg = Msg & vbCrLf & "Cypher Algorithm: WPA - Use Group Key"
    End Select
    GetInfo = Split((Msg), vbCrLf)
End Function

Public Function Connect(ByVal SSID As String) As Boolean
    Dim lRet As Long
    Dim udtConnect As WLAN_CONNECTION_PARAMETERS
    SSID = Trim(Left$(SSID, 15)) & Chr$(0)
    udtConnect.ConnectionMode = 0&
    udtConnect.dot11BssType = DOT11_BSS_TYPE.DOT11_BSS_TYPE_ANY
    udtConnect.Profile = StrPtr(SSID)
    lRet = WlanConnect(lHandle, udtList.InterfaceInfo.ifGuid, udtConnect, 0&)
    If lRet = 0 Then
        Connect = True
    End If
End Function

Public Function Disconnect() As Boolean
    Dim lRet As Long
    lRet = WlanDisconnect(lHandle, udtList.InterfaceInfo.ifGuid, 0&)
    If lRet = 0 Then
        Disconnect = True
    End If
End Function

Public Sub ReleaseHandle()
    Call WlanCloseHandle(lHandle, 0)
    Call Sleep(1000)
    ConIndex = 0
    lHandle = 0
    lVersion = 0
    Connected = ""
    lNumberOfnetworkItems = 0
    Erase bBuffer()
End Sub

Private Function MACtoString(bMAC() As Byte) As String
    Dim sTmp As String
    MACtoString = Right$("0" & Hex$(bMAC(0)), 2) & "-" _
        & Right$("0" & Hex$(bMAC(1)), 2) & "-" _
        & Right$("0" & Hex$(bMAC(2)), 2) & "-" _
        & Right$("0" & Hex$(bMAC(3)), 2) & "-" _
        & Right$("0" & Hex$(bMAC(4)), 2) & "-" _
        & Right$("0" & Hex$(bMAC(5)), 2)
End Function

Private Function TimeToString(File_Time As FILETIME) As String
    Dim tSerial As Single
    Dim File_Time_Local As FILETIME
    Dim sys_Time As SYSTEMTIME
    'convert the file time to a local file time
    If FileTimeToLocalFileTime(File_Time, File_Time_Local) Then
        'convert the local file time to the system time format
        If FileTimeToSystemTime(File_Time_Local, sys_Time) Then
            'calculate the DateSerial/TimeSerial values for the system time
            'dSerial = DateSerial(sys_Time.wYear, sys_Time.wMonth, sys_Time.wDay)
            tSerial = TimeSerial(sys_Time.wHour, sys_Time.wMinute, sys_Time.wSecond)
            'Debug.Print FormatDateTime(dSerial, vbLongDate) & "  " & FormatDateTime(tSerial, vbLongTime)
            TimeToString = FormatDateTime(tSerial)
        End If
    End If
End Function

Private Function ByteToStr(bArray() As Byte) As String
    Dim lPntr As Long
    Dim bTmp() As Byte
    On Error GoTo ByteErr
    ReDim bTmp(UBound(bArray) * 2 + 1)
    For lPntr = 0 To UBound(bArray)
        bTmp(lPntr * 2) = bArray(lPntr)
    Next lPntr
    Let ByteToStr = bTmp
    Exit Function
ByteErr:
    ByteToStr = ""
End Function

Private Function ByteToStr2(b() As Byte) As String
    Dim sDescription As String, bTmp() As Byte, lNullCharPos As Long
    bTmp = StrConv(b, vbUnicode)
    sDescription = String(UBound(bTmp), Chr(0&))
    sDescription = bTmp
    sDescription = StrConv(sDescription, vbFromUnicode)
    lNullCharPos = InStr(sDescription, Chr(0&)) - 1&
    If lNullCharPos Then
        ByteToStr2 = Left$(sDescription, lNullCharPos)
    End If
End Function

Private Sub Wait(ByVal Delay As Single)
    Dim t As Single
    t = Timer: Do: DoEvents: Loop Until Timer - t >= Delay
End Sub

2- UserForm Module:

Option Explicit

Private bRefreshing As Boolean

Private Sub UserForm_Activate()
    Call RefreshNetworks
End Sub

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
    If bRefreshing Then Cancel = True: Exit Sub
    Call ReleaseHandle
End Sub

Private Sub btnConnect_Click()
    With btnConnect
        If .Caption = "Connect" Then
            If Connect(lstSSID.Value) Then
                .Caption = "Disconnect"
            Else
                MsgBox "Connection failed.": Exit Sub
            End If
        Else
            If Disconnect Then
                .Caption = "Connect"
            Else
                MsgBox "DisConnection failed.": Exit Sub
            End If
        End If
    End With
    Call RefreshNetworks
End Sub

Private Sub lstSSID_Change()
    Call UpdateListBox(lstBBS)
End Sub

Private Sub RefreshNetworks()
    Dim aNetWorksNames() As String
    bRefreshing = True
    btnConnect.Enabled = False
    lblStatus.Caption = "Loading\Refreshing ...  Please,wait."
    Call SetUpListBox(lstBBS, False)
    lblWifiAdapterName = "[ " & GetWifiAdapterName & " ]"
    aNetWorksNames = GetNetWorksNames
    If ((Not aNetWorksNames) = -1&) Then
        bRefreshing = False: lblStatus.Caption = "": Exit Sub
    End If
    lstSSID.List = aNetWorksNames
    lstSSID.ListIndex = 0&
    lblNetWorksFound = "[ " & lstSSID.ListCount & " ]"
    Call SetUpListBox(lstBBS, True)
    Call UpdateListBox(lstBBS)
    btnConnect.Enabled = True
    lblStatus.Caption = ""
    bRefreshing = False
End Sub

Private Sub SetUpListBox(ByVal Lbx As MSForms.ListBox, ByVal bClear As Boolean)
    Dim vArray As Variant, vItem As Variant

    vArray = Array( _
        "bSSID (MAC):", _
        "Connected:", _
        "LinkQuality (Signal Strength):", _
        "PhyId:", _
        "BssType:", _
        "BssPhyType:", _
        "lRssi:", _
        "RegDomain:", _
        "BeaconPeriod:", _
        "Timestamp:", _
        "HostTimestamp:", _
        "CapabilityInformation:", _
        "ulChCenterFrequency:", _
        "wlanRateSet:", _
        "ulIeOffset:", _
        "ulIeSize:", _
        "BSS_TYPE:", _
        "Connectable:", _
        "PHY_TYPE:", _
        "Security Enabled:", _
        "Auth Algorithm:", _
        "Cypher Algorithm:" _
    )
With Lbx
    If bClear Then
        .Clear
    End If
    .ColumnCount = 2&
    .ColumnWidths = "120;220"
    For Each vItem In vArray
        .AddItem IIf(bClear, vItem, "")
    Next vItem
End With
End Sub

Private Sub UpdateListBox(ByVal Lbx As MSForms.ListBox)
    Dim uBSS As BSS_INFO, arSSID() As String
 
    uBSS = GetBSS(lstSSID.Value)
    arSSID = GetInfo(lstSSID.ListIndex)
    If Not ((Not arSSID) = -1&) Then
        With Lbx
            .List(0, 1) = uBSS.MAC
            .List(1, 1) = arSSID(0&)
            .List(2, 1) = uBSS.uLinkQuality & " %"
            .List(3, 1) = uBSS.uPhyId
            .List(4, 1) = uBSS.dot11BssType
            .List(5, 1) = uBSS.dot11BssPhyType
            .List(6, 1) = uBSS.lRssi
            .List(7, 1) = uBSS.bInRegDomain
            .List(8, 1) = uBSS.usBeaconPeriod
            .List(9, 1) = uBSS.ullTimestamp
            .List(10, 1) = uBSS.ullHostTimestamp
            .List(11, 1) = uBSS.usCapabilityInformation
            .List(12, 1) = uBSS.ulChCenterFrequency & " GHz"
            .List(13, 1) = uBSS.uRateSetLength
            .List(14, 1) = uBSS.ulIeOffset
            .List(15, 1) = uBSS.ulIeSize
            .List(16, 1) = arSSID(1&)
            .List(17, 1) = arSSID(2&)
            .List(18, 1) = arSSID(3&)
            .List(19, 1) = arSSID(4&)
            .List(20, 1) = arSSID(5&)
            .List(21, 1) = arSSID(6&)
        End With
        If lstBBS.List(1&, 1&) = "FALSE" Then
            btnConnect.Caption = "Connect"
        Else
            btnConnect.Caption = "Disconnect"
        End If
    End If
End Sub

 

[johnnyL]

Same RTE 9 error on the last 2 lines for the listbox values:

            .List(20, 1) = arSSID(5&)   ' SSID named '2984' seems to cause the RTE 9  error on this line
            .List(21, 1) = arSSID(6&)

 

[Jaafar Tribak]

Same RTE 9 error on the last 2 lines for the listbox values:

            .List(20, 1) = arSSID(5&)   ' SSID named '2984' seems to cause the RTE 9  error on this line
            .List(21, 1) = arSSID(6&)

Strange! Add this line Debug.Print UBound(Split((Msg), vbCrLf)) at the end of the GetInfo function located in the bas_API module and see what output you get in the immediate window.

Edit:
Actually add this :
Debug.Print UBound(Split((Msg), vbCrLf))
Debug.Print Msg

 

[johnnyL]

When the first RTE 9 occurs on line:

            .List(21, 1) = arSSID(6&)

The Immediate window shows:
5

 

[johnnyL]

For the RTE 9 error on line:

            .List(20, 1) = arSSID(5&)

The Immediate window shows:
4

 

[Jaafar Tribak]

It should return 6

 

[Jaafar Tribak]

Place this debug.Print before the line where the first error occurs: (in the userform UpdateListBox SUB)

            .List(19, 1) = arSSID(4&)
            Debug.Print .List(19, 1)
            .List(20, 1) = arSSID(5&)
            .List(21, 1) = arSSID(6&)

What value do you get ?

 

[johnnyL]

Sorry, I missed your edited post above.

Here is the updated info:

For the RTE 9 on line:

            .List(21, 1) = arSSID(6&)

The Immediate window shows:
5
TRUE
BSS: Infrastructure
TRUE
TRUE
Auth Algorithm: RSNA with Pre-shared Keys
Cypher Algorithm: AES - CCMP

 

[johnnyL]

Place this debug.Print before the line where the first error occurs: (in the userform UpdateListBox SUB)

            .List(19, 1) = arSSID(4&)
            Debug.Print .List(19, 1)
            .List(20, 1) = arSSID(5&)
            .List(21, 1) = arSSID(6&)

What value do you get ?

Auth Algorithm: RSNA with Pre-shared Keys