{"id":4417,"date":"2023-07-11T06:39:08","date_gmt":"2023-07-11T06:39:08","guid":{"rendered":"https:\/\/statorials.org\/id\/hapus-file-vba\/"},"modified":"2023-07-11T06:39:08","modified_gmt":"2023-07-11T06:39:08","slug":"hapus-file-vba","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/hapus-file-vba\/","title":{"rendered":"Cara menghapus file menggunakan vba (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan pernyataan Kill<\/strong> di VBA untuk menghapus file Excel tertentu di folder tertentu.<\/span><\/p>\n

Berikut adalah cara umum untuk menggunakan pernyataan ini dalam praktik:<\/span><\/p>\n

 SubDeleteFile<\/span> ()\n\n    On Error Resume Next<\/span>\n    Kill \"C:\\Users\\Bob\\Desktop\\My_Data\\soccer_data.xlsx\"\n    On Error GoTo 0<\/span>\n\nEnd Sub\n<\/span><\/strong><\/span><\/pre>\n
 Makro khusus ini menghapus file Excel bernama Soccer_data.xlsx<\/strong> yang terletak di folder berikut:<\/span><\/p>\n
 C:\\Pengguna\\Bob\\Desktop\\Data_Saya<\/strong><\/span><\/p>\n
 Baris On Error Resume Next<\/strong> memberitahu VBA bahwa jika terjadi kesalahan dan file tidak ditemukan, tidak ada pesan kesalahan yang ditampilkan.<\/span><\/p>\n
 Kami kemudian menggunakan On Error GoTo 0<\/strong> untuk mengatur ulang pesan kesalahan ke pengaturan default.<\/span><\/p>\n
 Jika Anda ingin menampilkan pesan kesalahan jika file tidak ditemukan, cukup hapus dua baris ini dari kode.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Menghapus File Menggunakan VBA<\/strong><\/span><\/h2>\n
 Misalkan kita memiliki folder berikut yang berisi tiga file Excel:<\/span> <\/p>\n
\"\"<\/p>\n
 Katakanlah kita ingin menggunakan VBA untuk menghapus file bernama Soccer_data.xlsx<\/strong> .<\/span><\/p>\n
 Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n
 SubDeleteFile<\/span> ()\n\n    On Error Resume Next<\/span>\n    Kill \"C:\\Users\\Bob\\Desktop\\My_Data\\soccer_data.xlsx\"\n    On Error GoTo 0<\/span>\n\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Setelah kita menjalankan makro ini dan membuka foldernya lagi, kita akan melihat bahwa file bernama football_data.xlsx<\/strong> telah dihapus:<\/span> <\/p>\n
\"\"<\/p>\n
 Semua file lainnya tetap utuh di folder tersebut.<\/span><\/p>\n
 Jika Anda ingin menampilkan pesan kesalahan jika file tidak ada, Anda dapat menggunakan makro berikut:<\/span><\/p>\n
 SubDeleteFile<\/span> ()\n\n    Kill \"C:\\Users\\Bob\\Desktop\\My_Data\\soccer_data.xlsx\"\n\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Saat kami menjalankan makro ini, kami menerima pesan kesalahan berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Kami menerima pesan kesalahan ini karena file football_data.xlsx<\/strong> telah dihapus dan tidak ada lagi di folder tersebut.<\/span><\/p>\n
 Catatan<\/strong> : Perlu diketahui bahwa pernyataan Kill<\/strong> menghapus file secara permanen dan tidak hanya mengirimkannya ke Sampah.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n
 VBA: Cara menghitung jumlah lembar dalam buku kerja<\/a>
 VBA: Cara mengekstrak data dari buku kerja lain
 VBA: Cara menghapus sheet jika namanya mengandung teks tertentu<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan pernyataan Kill di VBA untuk menghapus file Excel tertentu di folder tertentu. Berikut adalah cara umum untuk menggunakan pernyataan ini dalam praktik: SubDeleteFile () On Error Resume Next Kill “C:\\Users\\Bob\\Desktop\\My_Data\\soccer_data.xlsx” On Error GoTo 0 End Sub Makro khusus ini menghapus file Excel bernama Soccer_data.xlsx yang terletak di folder berikut: C:\\Pengguna\\Bob\\Desktop\\Data_Saya Baris On […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"\nCara Menghapus File Menggunakan VBA (dengan Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus file menggunakan VBA, dengan beberapa contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/hapus-file-vba\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghapus File Menggunakan VBA (dengan Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus file menggunakan VBA, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/hapus-file-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T06:39:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/delfiles1.jpg\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/hapus-file-vba\/\",\"url\":\"https:\/\/statorials.org\/id\/hapus-file-vba\/\",\"name\":\"Cara Menghapus File Menggunakan VBA (dengan Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T06:39:08+00:00\",\"dateModified\":\"2023-07-11T06:39:08+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus file menggunakan VBA, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/hapus-file-vba\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/hapus-file-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/hapus-file-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghapus file menggunakan vba (dengan contoh)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Menghapus File Menggunakan VBA (dengan Contoh) - Statorials","description":"Tutorial ini menjelaskan cara menghapus file menggunakan VBA, dengan beberapa contoh.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/id\/hapus-file-vba\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghapus File Menggunakan VBA (dengan Contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara menghapus file menggunakan VBA, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/hapus-file-vba\/","og_site_name":"Statorials","article_published_time":"2023-07-11T06:39:08+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/delfiles1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/hapus-file-vba\/","url":"https:\/\/statorials.org\/id\/hapus-file-vba\/","name":"Cara Menghapus File Menggunakan VBA (dengan Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T06:39:08+00:00","dateModified":"2023-07-11T06:39:08+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus file menggunakan VBA, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/hapus-file-vba\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/hapus-file-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/hapus-file-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghapus file menggunakan vba (dengan contoh)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4417"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4417"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4417\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4417"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}