Kill Command in Excel - Is it Dangerous?

แชร์
ฝัง
  • เผยแพร่เมื่อ 2 ก.พ. 2025

ความคิดเห็น • 7

  • @mageshwaranmeena1724
    @mageshwaranmeena1724 2 หลายเดือนก่อน +1

    How to Kill open file,
    If the file is open it is not even give notification, simply ignoring the kill statement.

  • @alfonso444able
    @alfonso444able 2 ปีที่แล้ว +1

    Its possible to erase the same file that has the macro ?

  • @jeni448
    @jeni448 2 ปีที่แล้ว +3

    Is it possible to recover the deleted file in the recycle bin?

    • @nurserytoys
      @nurserytoys 2 ปีที่แล้ว +1

      *same question*

    • @TeachExcel
      @TeachExcel  2 ปีที่แล้ว

      No, it will not be there! You will probably have to download file recovery software to get the files - though I have not tested doing that on recent versions of Windows so I can't verify it 100%
      In my full VBA course, we go over the concept of only ever using Kill on files that the current macro has created and I would recommend this in order to be safe.
      Or, you could show the user a pop-up window and ask them to verify the file delete - this may or may not work well for your use-case.

  • @Praveen-cl9lf
    @Praveen-cl9lf 2 ปีที่แล้ว

    How to add a confirmation msg for this kill command ?

  • @rionov86
    @rionov86 2 ปีที่แล้ว +1

    Im gonna used it when my employer mess with me 😂😂😂, leave it in the comp as a time bomb