No video
How to create Monitoring tool | Online / Offline - Response Time
How to create your own ping tool with Microsoft Excel.
VBA Code docdro.id/tIVl618
Apple MacBook Air amzn.to/44WhPou
You subscribe now because it's free / netvn82
#netvn #excel #pingpong
Пікірлер: 64
Thumbs UP ! nice job... small modifications and it is personalized ! KEEP UP !
Thank u brother, great work
I did as what you're shown and it works. Please give the code if I want to clear out the Offline when it online back. Thank you
Hey, Many thanks for this video, two questions, 1- I am getting a popup msg from my antivirus that a suspicious macro has been stopped, any advise? 2- Would you pls add a column for the "Available bandwidth between source & Destination" ? or to be in a separate sheet. (assuming that we have multiple sites, and we need to know the available bandwidth between each site & the control room).
GREAT SIR , VERY THANK FULL YOUR VIDEO SIR
Very helpful video
❤️ from Karnataka. India
Idea for video, instead of in status whether online or offline, be Status 200 or other code that the page responds to
Thank
thanks
Very useful 👍 Thank you
@NETVN82
2 жыл бұрын
Welcome 😊
Thank you very much, Worked for me..
@NETVN82
Жыл бұрын
You're welcome!
Can we get number of ping drop and success report as well?
Can it capture the FQDN as well please.
Gracias amigo, realicé paso a paso y funcionó correctamente.
Can I make it give an event in the next column whenever the IP is offline and keep the old event?
Can u create a tool of centralised event viewer?
can you guide me how to use this code in excel sheet or can you please point me to souce excel sheet
🙌
How about doing in the google sheet?
Топчик ! -)
and on microsoft visio ? it's possible ?
Set objshell = CreateObject("Wscript.Shell") this is showing error while debug please help
i have using Firewall for internet Provider its not connecting with me
From Cameroun
Can we do snmp monitoring using this method?
could you show if the router to access using vpn
i am getting boolcode error on Line 4, can you please upload your file?
how to save log offline result. pls guide
Need network tickets tools how to use bro
what is the contents of the data sheet
how can i get only of line notification on whatss app ??
Super
@NETVN82
Жыл бұрын
Thanks
Dear sir, kindly provide some solutions for auto email sent from tools to particular email whenever some device goes out of network/ disconnect from network. It would be helpful
how to download excel file
Can I get excel file?
file not found
getting error for this row=> For introw = 3 To ActiveSheet.Cells(65536, 3).End(xlUp).Row , trying to run it on excel 2007 run time error 1004 object defined error
@nacsabalazs
Жыл бұрын
xlUP = lower case "X" lower case "L" upper case "U" upper case "P"
Mit Exel?
this will make load traffic becuse the ping is Continuous
Code is not working can you edit the code please
Sheets("DATA").Cells(introw, 1).Value = 0 mine always error in that part
@SeaWolfy
3 жыл бұрын
Rename your excel sheet with DATA
@CarloLabati
2 жыл бұрын
@@SeaWolfy wath ?
@kendejichi6963
2 жыл бұрын
@@SeaWolfy
@Pian0Tears
Жыл бұрын
@@SeaWolfy Thank you
Give excel file
End count total online & offline devices add this vba code
@nicokompier2819
2 жыл бұрын
=COUNTIF(D3:D28;"Online") or "Offline"
how to stop?
@nicokompier2819
2 жыл бұрын
Press ESC. Not nice. Or Add a sub with Sub Break() End End Sub And create a Stop button
@juanpompe1683
Жыл бұрын
how?
Run-time error 9 Sheets("DATA").Cells(introw, 1).Value = 0
@pityuszabo2574
3 жыл бұрын
create a secondary Sheet called DATA...
@OborocV
3 жыл бұрын
@@pityuszabo2574 english no, pls xlsx link download, tanchs
@pityuszabo2574
3 жыл бұрын
enable the MACRO, and thank for NET VN network ! Good Luck
@CarloLabati
2 жыл бұрын
same here
Thanks for 100 Ab 250 krwado ❤ Love you all ❤❤❤