Forum Discussion
Excel (365 & 2016) with network information...and much more Information to Filter.
With Excel (365 & 2016) Network information, information about Local Network Connectivity, Test Connection to a Specific Web URL, WiFi SSID information
...and much more information to filter with a button.
I was trying to create a tool that would allow me to filter the necessary information from all the PCs I need to work on using a USB stick.
I came across an old file that I edited and added additional information to the code.
I'd like to share this file (Help for self-help). If anyone finds it useful, or would like additional tips or information, please feel free to send me feedback.
If it doesn't help you...just ignore it.
I welcome any constructive comments.
* After loading the file, be sure to activate all macros.
Happy Excel-ing! 🙂
14 Replies
First I see is
Perhaps since I have a lot of global groups, didn't dig.
Sergei,
in which code or button/sheet are you experiencing this error?
Could it be caused by the "Blocked by group" policy?
Thanks in advance
NikolinoDE​ , "Get Network Info" button.
have no idea about the policy you mentioned.
That sounds like a really handy tool, especially for IT admins or support teams who need quick insights into network and connectivity details without installing additional software. I like the idea of centralizing things like local network connectivity, Wi-Fi SSID, and test connections directly in Excel — it makes troubleshooting more accessible for people who are already comfortable working in spreadsheets.
Using macros to pull this information together is a clever approach, though it’s good you reminded people to enable them since that’s often overlooked. Sharing the file as a “help for self-help” resource is a great way to let others adapt it to their own environments.
I’d be curious to see how you structured the filtering button — that could be especially useful for narrowing down results when working across multiple machines. Thanks for sharing this, and I’m sure others in the community will find value in it.
Thank you for your feedback, too; that was exactly the idea behind it 🙂.
Thanks to Kidd_Ip, I've steered it in the right direction.
Of course, any suggestions for improvement are welcome.
Would suggest:
• Auto-Detect Network Adapter Info: Include IP address, MAC address, gateway, DNS servers.
• Ping Test & Web URL Check: Add a macro that pings a list of URLs and logs response times or failures.
• WiFi SSID & Signal Strength: Use to grab SSID and signal quality.
• Export to CSV or Email: Add a button to export filtered results or email them directly (For Outlook).
• System Info Snapshot: Pull OS version, hostname, uptime, and user account info.
• Offline Mode: Cache results locally if no internet is available, then sync when online.I've expanded the file based on your suggestions and hope it meets your (and many others' 🙂) expectations. I'll continue to develop it and add additional features, such as checking a computer's battery and power (as far as the computer allows it or the option is available).
Thanks again for your feedback; it was very helpful 🙂.
Very helpful codes. Thank you for sharing!
Thank you for your feedback and suggestions 🙂. I will try to implement them in a timely manner, as far as this is possible with Excel.
