How to create a Ping monitoring tool with Microsoft Excel

Поділитися
Вставка
  • Опубліковано 25 бер 2021
  • How to ping multiple IP address using Microsoft Excel
    Download code docdro.id/JfZv0wy
    NETGEAR WiFi 6 Router amzn.to/3Ov8X3S
    TP-Link WiFi 6 Router amzn.to/3QjafAt
    You subscribe now because it's free / netvn82
    #netvn #microsoftexcel #pingpong
  • Навчання та стиль

КОМЕНТАРІ • 368

  • @martinmacapobre1262
    @martinmacapobre1262 3 роки тому +9

    This is what I am looking for. thanks a lot :)

  • @bone1411
    @bone1411 3 роки тому +2

    Thank you very much. Exactly what i needed and works perfect!

  • @eyhabsoft
    @eyhabsoft 3 роки тому +1

    Thank you for all free tutorials you give us. God bless you 👍

  • @Shutyourjibbs
    @Shutyourjibbs 2 роки тому +1

    Amazing! This is exactly what I needed! Thank you!

  • @zaheerraihan1249
    @zaheerraihan1249 3 роки тому +2

    You are genius.
    Thank you man 💕

  • @CiRiC664
    @CiRiC664 3 роки тому +73

    When they interview and ask how good are you in Ms Excel.
    This guy be like: bring me laptop. I will hacked your system using excel.

    • @abdainawi
      @abdainawi 3 роки тому +1

      1st he will respond text to speech

  • @mteomteo747
    @mteomteo747 3 роки тому +2

    Great, this is what i need. Keep it up.

  • @johnzavax
    @johnzavax 3 роки тому

    Much needed. Thanks a lot 😁

  • @hornickt
    @hornickt 3 роки тому

    Thank you for the great new video and the download link. Great work.

  • @lydhely7366
    @lydhely7366 3 роки тому

    Thanks a lot for this !

  • @PLScience
    @PLScience 3 роки тому +1

    I was in need of this 10 years ago.

  • @raulherrera3233
    @raulherrera3233 2 роки тому

    Thank you so much! Exactly what I needed. Greetings from Panama!

    • @NETVN82
      @NETVN82  2 роки тому

      Glad it helped!

  • @SyfulIslam-hh8dx
    @SyfulIslam-hh8dx 4 місяці тому

    Thank you for all free tutorials you give us. God bless you

  • @hectorbolivar83
    @hectorbolivar83 3 роки тому

    Amazing as always happy 😊 thanks a lot

  • @ThangTran-hi3es
    @ThangTran-hi3es 3 роки тому +1

    Good job Visual Basic

  • @electric9278
    @electric9278 3 роки тому +254

    Next video: How to built a OS using Ms Word 😉

  • @vishalmakwana2213
    @vishalmakwana2213 3 роки тому

    Thanks More Videos Excel learning 👍❤️👍

  • @joaomarcelosantosdesousa430
    @joaomarcelosantosdesousa430 3 роки тому +3

    Deu certo aqui para mim tambem, show de bola. Brazil

  • @rameshpk8848
    @rameshpk8848 3 роки тому

    Thanks for the video. Good one for beginners like me..

  • @_-_ttt_-_
    @_-_ttt_-_ 3 роки тому +1

    Holy shit! Subbed.
    It will help me with literally whole corp network diagnosis♥️

  • @andrewwickes1091
    @andrewwickes1091 3 роки тому

    I am definitely going to use this for footprinting for pentesting and ethical hacking.

  • @phuocduong663
    @phuocduong663 3 роки тому

    Wow thank you so much

  • @SamehMustafa007
    @SamehMustafa007 3 роки тому +1

    Perfect perfect 👌👍👍

  • @AEfsaenti
    @AEfsaenti Рік тому +1

    Thank you very much.

  • @gururajprabhu4187
    @gururajprabhu4187 3 роки тому +5

    Is it possible to put separate tab to capture date and time when the ping went offline and one more tab when it came online

  • @deshdeepakgoel1024
    @deshdeepakgoel1024 3 роки тому +8

    Nice, please also give some idea to get Mac address in saperate column near online offline status column

  • @arjunmurugan8084
    @arjunmurugan8084 2 роки тому +1

    Thanking you very much. It's working perfect !

    • @NETVN82
      @NETVN82  2 роки тому

      You're welcome!

  • @abdullahalklbani7454
    @abdullahalklbani7454 2 роки тому

    😊 السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ 😊
    Thank you very much 😊
    That was amazing 👏

  • @dadatata7228
    @dadatata7228 3 роки тому

    thanks you are the best

  • @BillSummers-rv7kc
    @BillSummers-rv7kc Рік тому

    This is great. Thank you!

    • @NETVN82
      @NETVN82  Рік тому

      You're very welcome!

  • @kcraigo
    @kcraigo 2 роки тому +1

    Works perfect! Thank you!

    • @NETVN82
      @NETVN82  2 роки тому

      You're welcome!

    • @heisenbergwaffles
      @heisenbergwaffles 6 місяців тому

      Did you implement this in a corporate network?

  • @chhelsopheak5725
    @chhelsopheak5725 2 роки тому

    Amazing videos, hope the next video is how to use remote desktop without lock screen.

  • @awannet
    @awannet 3 роки тому

    Thanks.. 👍👍👍👍

  • @shikukunipashe3495
    @shikukunipashe3495 3 роки тому

    Good work..

  • @claudio1028
    @claudio1028 Рік тому

    Muito obrigado! Funcionou aqui! Só tive que adaptar para PT-BR no código de Sheet1 para Planilha1!💡💡💡

  • @sachinpoly9052
    @sachinpoly9052 3 роки тому +7

    you deserve more subscribers

  • @rodolforodriguez70
    @rodolforodriguez70 10 місяців тому

    I am going to be waiting for it

  • @birincyray
    @birincyray 3 роки тому

    Thank you sir

  • @blueccltchois6135
    @blueccltchois6135 3 роки тому +1

    엑셀을 어느정도 한다 생각하는데... 이건 뭐죠? 배우싶습니다 ㅜㅜ

  • @pixelhated348
    @pixelhated348 Рік тому

    still usable. for some reason The command wasnt running coming from vba because it was thinking that the numbers in the string were still strings and wasnt accepting it as an actual value.
    but other than that runs great

  • @navedwaris2363
    @navedwaris2363 3 роки тому

    Thank You........

  • @HichemComputer
    @HichemComputer 3 роки тому

    Thank you

  • @aung.thuaye
    @aung.thuaye 2 роки тому

    Thanks. Working correctly.

  • @shoal2242
    @shoal2242 3 роки тому

    You bloody genius😂

  • @saleimQ8
    @saleimQ8 Рік тому

    Thanks!

  • @LegendaryPhoenixReaction
    @LegendaryPhoenixReaction 10 місяців тому +1

    Wow you are the best and got a subscriber :cheers:

  • @sundareshg2683
    @sundareshg2683 3 роки тому

    Great 👍

  • @mattri483
    @mattri483 Рік тому

    Thank you very much. 👍

  • @aymanhout
    @aymanhout 3 роки тому

    Great 🎉

  • @oguzsahinn
    @oguzsahinn 3 роки тому +1

    Thank you.
    We have more than 200 Client and now ı ll see on one page which is working

    • @nsbirdsformns4515
      @nsbirdsformns4515 3 роки тому

      Bro actually all time it will online status only showing every time I have to put offline but it showing online

    • @nickvalera1017
      @nickvalera1017 3 роки тому

      @@nsbirdsformns4515 probably theyre experiecing technical concern or intermitent network connection, i was just thinking is anyone can actually add more columns to show real time speed test

  • @bile-choolfamily6294
    @bile-choolfamily6294 3 роки тому

    thank u

  • @phucnbv
    @phucnbv 10 місяців тому

    thank you very much. I really admire you

    • @NETVN82
      @NETVN82  10 місяців тому

      So nice of you

  • @a.useronly2266
    @a.useronly2266 3 роки тому

    Thanks

  • @brahmaviewer
    @brahmaviewer 3 роки тому

    thx!!!

  • @nims300
    @nims300 3 роки тому

    Superb

  • @danielmajewski8783
    @danielmajewski8783 3 роки тому

    good job :)

  • @nickvalera1017
    @nickvalera1017 3 роки тому

    just wanna confim is this for LAN (local network connection)? i can exexute the program but when i tried accessing other IP addresss it says offline (but i noticed 2 of my devices connected in the same modem and it says online)

  • @AByteAtTech
    @AByteAtTech 3 роки тому

    Hi, great addon would be on adding that if Offline then it sends a email containing in Subject the IP Addres and Name of which is offline if offline for more then 10 checks or something similar!

  • @akashsharma2610
    @akashsharma2610 3 роки тому +2

    I have questions
    1. I want the destination ip should show in right side where start and stop have then what we have to change?
    2. Are they ping packet going simultaneously to every destination or one by one each as i shaw they were blinking one by one?
    3.if i add one more ip in those ip row so that will also work?

    • @NETVN82
      @NETVN82  3 роки тому

      you add one more ip in that ip row it still works normally

  • @jorgealexanderbenalcazar4601
    @jorgealexanderbenalcazar4601 3 роки тому

    En caso que pierda ping o conexion de una alerta sonora ?

  • @versaviptela4737
    @versaviptela4737 3 роки тому

    thanks

  • @engineerlocalhost
    @engineerlocalhost 3 роки тому

    NICE SIR

  • @manoushow6658
    @manoushow6658 3 роки тому +2

    Use the zom closest to the screen to compose poems. I access the Internet through my mobile phone. I don't have a notebook. I am Brazilian. I do not speak English. I use English translation.

  • @Mjnettv
    @Mjnettv 3 роки тому

    Amazing

  • @ernestomercadomaciasat4rer896
    @ernestomercadomaciasat4rer896 3 роки тому +1

    Excelente,^^

  • @ahfei233
    @ahfei233 3 роки тому

    Hello, could you write monitoring the temp for every switch device?

  • @MrAimalsultani
    @MrAimalsultani 2 роки тому

    Well_done

  • @elfirizalsamsudin1979
    @elfirizalsamsudin1979 3 роки тому

    This is very cool...will the vb script allow you to ssh to a different host first then only run the ping?

  • @enggaabow3801
    @enggaabow3801 3 роки тому

    His voice🌻❤😳

  • @Freenotes4you
    @Freenotes4you 3 роки тому

    nice man can you make video if ip is offline then automatically send email or send telegram notification its really help us

  • @Ravel__
    @Ravel__ 3 роки тому +2

    Obrigado!!!

  • @vthuy154
    @vthuy154 3 роки тому

    I have an question, in the "IDLE" how to set Sheet1 from video to multi sheet with different name?

  • @tunogsound2563
    @tunogsound2563 3 роки тому

    Nice one! haha

  • @herydsinau
    @herydsinau 3 роки тому

    Nice

  • @archer9250
    @archer9250 3 роки тому +4

    Привет, сможешь ли ты помочь? Хотелось бы пинговать цепочку коммутаторов и чтобы это отображалось в веб форме.

  • @sawomirgmur7497
    @sawomirgmur7497 Рік тому

    thanks brother

  • @ecgarcia
    @ecgarcia 3 роки тому +2

    Any help to make it work with Libre Office?

  • @sandol2225
    @sandol2225 2 роки тому

    thank you for the video. Is possible you can find city name instead on/off line?

  • @dharvey24
    @dharvey24 3 роки тому +8

    Solved Error - "Method or data member not found" in the vba replace sheet1 with Sheets("Sheet1") in each instance it occurs. Don't replace the whole line just 'sheet1'. For example - Do Until sheet1.Range("F1").Value = "STOP" WILL NOW BE - Do Until Sheets("Sheet1").Range("F1").Value = "STOP"

    • @FinaLBeaTzGaming
      @FinaLBeaTzGaming 3 роки тому +1

      Thanks for the fix

    • @egelden
      @egelden 3 роки тому +1

      Another method would be to use ActiveSheet.Range("F1").Value = "STOP" instead of sheet1.Range("F1").Value = "STOP". In this case you can name the sheet whatever you want to.

    • @alejandrocoderch488
      @alejandrocoderch488 3 роки тому

      Sheet1 will not work if your Excel is not in English. Because of that, you can use the name of the Sheet or its caption, like you've said, Sheets("CaptionOfTheSheet")

  • @leonardo_oliveira241
    @leonardo_oliveira241 3 роки тому

    That's why I always say that my Excel is basic!

  • @Krish9811
    @Krish9811 11 місяців тому

    Is it possible to add Time in the next column, since when any line is down ? This is very much needed tool, I searched a lot for his. Thank You Very Much.

  • @mordekaiser_1312
    @mordekaiser_1312 3 роки тому

    why would you use hungarian notation (kinda) for variable names instead of properly giving types with the As keyword? just asking

  • @ProjeAdam.
    @ProjeAdam. 2 роки тому

    thank bro

  • @ricardocarlos5474
    @ricardocarlos5474 3 роки тому

    Jaja qué bonito !!!

  • @vlogmotofi4752
    @vlogmotofi4752 3 роки тому +5

    Would be cooler if you added the time for latency monitoring. 👍

    • @SeaWolfy
      @SeaWolfy 3 роки тому +1

      Did you found something about that? I'm trying to do the same but can't find anything..

    • @akhilskrishnan
      @akhilskrishnan 3 роки тому +2

      I am also looking for that

    • @SeaWolfy
      @SeaWolfy 3 роки тому

      He did it
      ua-cam.com/video/KYl0oEw2edE/v-deo.html

    • @iHammouda
      @iHammouda Рік тому

      @@SeaWolfy Are you still looking for this feature?

  • @fowroz1989
    @fowroz1989 3 роки тому

    @Net VN : is this possible to ping IP Address with specific port number

  • @amitpatil6178
    @amitpatil6178 2 роки тому

    Nice and useful information. Thanks for sharing. Can you show us How to get a notification or mail alert if any IP address failed to ping.

  • @sridharv2270
    @sridharv2270 3 роки тому

    Using this, shall we can check health status of all vm servers... if yes means we need to put this code in master server or our desktop itself?

  • @janusviborgolesen9613
    @janusviborgolesen9613 3 роки тому +1

    Great video.
    Could it be possible to use the command "arp" to add MAC address to the IP addresses which were online?

    • @SanthoshBalajiRamesh
      @SanthoshBalajiRamesh Рік тому +1

      this exact requirement i have made a video
      ua-cam.com/video/0nDUNp19_OU/v-deo.html

  • @juanpompe1683
    @juanpompe1683 Рік тому

    Holam como estas, sabes que no resuelve a nivel lan local, a que se podria deber?

  • @meshachchilemu9180
    @meshachchilemu9180 3 роки тому

    WOW I did it

  • @wanderson34456
    @wanderson34456 3 роки тому

    Wow!

  • @eminence5223
    @eminence5223 3 роки тому

    This is very useful video thank you very much,
    i have a doubt in this if we have 50 ip address to test how it is working after finish 50 ip address test then only it will check first ip or the each ip will check each sec
    can you please help me to clear on this

  • @otrociber4506
    @otrociber4506 3 роки тому

    Y para hacer ping, pero una red GPON, y que se muestre de esta misma manera. Cómo puedo hacer ?

  • @TungVu-jm1eo
    @TungVu-jm1eo 3 роки тому

    Hay qua ne.

  • @alexandrd7428
    @alexandrd7428 3 роки тому

    Красавчик)

  • @fernandoschnaidt210
    @fernandoschnaidt210 Рік тому

    Hi is possible have a data of the ip a d time out? To reports?

  • @yeswanth56
    @yeswanth56 3 роки тому +1

    If possible to send whatsapp message in excel through different names

  • @fabricioreyes2668
    @fabricioreyes2668 3 роки тому +2

    Me interesó, el video, por alguna casualidad no lo podría hacer en español para entenderle mas al tema

    • @paulinoramirez9529
      @paulinoramirez9529 3 роки тому +1

      Tampoco es que explique mucho el tema. Sólo te dice que hacer. Lo cuál lo logras sólo viendo el vídeo. Pero no da detalles del tema

  • @avitripathi8967
    @avitripathi8967 Рік тому

    Please tell me what to do online/offline status is showing in IP address column not in ping status bar.