I have decided to post this code here because the OP that it was originally written for has not responded back.
This code, I hope, is an open source project that I hope many coders will contribute to make it even better than what I have come up with thus far.
The code I have thus far:
Takes the data received from a cmd prompt window command of 'netsh wlan show networks mode=BSSID' and saves much of the data received into an array and at the end it displays the array data to a sheet.
The data gathered from that will display the SSID Name, Signal level, Band used, Channel used, Radio type, Mac Address, Authorization Algorithm, Encryption, & NetworkType.
I am hoping that with the code I am originally providing, people will chime in with how to add additional data for each of the available WIFI networks.
Ok, now on to the code that I am providing for starters ... I will have to post this over two different posts due to the limitations here on this site
Part 1 of code...