{"id":1545,"date":"2023-11-17T11:10:09","date_gmt":"2023-11-17T11:10:09","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/menghapus-berkas\/"},"modified":"2023-12-06T06:19:14","modified_gmt":"2023-12-06T06:19:14","slug":"menghapus-berkas","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/menghapus-berkas\/","title":{"rendered":"Bagaimana cara menghapus file menggunakan vba di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2116938877\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Untuk menghapus file Excel dari folder, Anda bisa menggunakan dua metode berbeda. Metode pertama adalah pernyataan \u201cBunuh\u201d yang mengambil jalur file untuk mereferensikan file yang ingin Anda hapus. Metode kedua adalah objek FileSystemObject yang memiliki metode terkait untuk menghapus file.<\/p><p> Untuk menggunakan kode-kode ini, buka VBE (Code Editor) dari tab pengembang.<\/p><h2 class=\"wp-block-heading\"> Hapus file menggunakan VBA (fungsi Kill)<\/h2><p> Fitur kill membantu Anda menghapus satu file atau beberapa file dan menggunakan wildcard untuk menghapus banyak file. Di bawah ini adalah satu baris kode yang menghapus file dari folder yang saya miliki di desktop. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Kill \"C:UsersDellDesktopSample Datafile-one.xlsx\"<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53303\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-un-fichier-en-utilisant-la-fonction-vba-kill.png\" sizes=\"auto, \" srcset=\"\" alt=\"hapus file menggunakan fungsi vba kill\" width=\"695\" height=\"167\"><\/figure><\/div><p> Kode ini akan menampilkan kesalahan jika buku kerja yang Anda tentukan untuk dihapus tidak ada.<\/p><p class=\"content-box-grey\"> <em>Tautan yang berguna: <a href=\"https:\/\/exceladvisor.org\/id\/jalankan-makro-2\/\">Jalankan makro<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/id\/merekam-makro\/\">Perekam makro<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/id\/editor-visual-dasar\/\">Editor Visual Basic<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/id\/buku-catatan-makro-pribadi\/\">Buku Pegangan Makro Pribadi<\/a><\/em><\/p><h2 class=\"wp-block-heading\"> Hapus semua file dalam satu folder menggunakan VBA<\/h2><p> Dan jika Anda ingin menghapus semua file yang ada dalam satu folder, Anda dapat menggunakan wildcard. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Kill \"C:UsersDellDesktopSample Data*.xl*\"<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53304\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-supprimer-tous-les-fichiers-dun-dossier-a-laide-de-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"hapus semua file dalam satu folder menggunakan vba\" width=\"693\" height=\"196\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Hapus file menggunakan FileSystemObject (Objek)<\/h2><p> Objek sistem file memungkinkan Anda mengakses sistem file komputer. Anda dapat mempelajari lebih lanjut dari sini, tapi sekarang mari kita menulis kode untuk menghapus file.<\/p><ul><li> Pertama, Anda perlu mendeklarasikan variabel yang akan digunakan dalam kode sebagai Binder dan FileSystemObject. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-hapus-file-menggunakan-objek-sistem-file\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-supprimer-un-fichier-a-laide-de-lobjet-systeme-de-fichiers.png\" sizes=\"auto, \" srcset=\"\" alt=\"delete a file using the file system object\" width=\"354\" height=\"198\"><\/li><li> Setelah itu, gunakan fungsi buat objek untuk mengembalikan FileSystemObject dengan menugaskannya ke variabel FSO. <br><img loading=\"lazy\" decoding=\"async\" title=\"Fungsi pembuatan 4 objek\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-creer-une-fonction-dobjet.png\" sizes=\"auto, \" srcset=\"\" alt=\"create object function\" width=\"509\" height=\"186\"><\/li><li> Selanjutnya, tetapkan jalur ke variabel \u201cmyFile\u201d untuk menavigasi ke file yang ingin Anda hapus. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-tetapkan-jalur-ke-file-saya\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-assigner-le-chemin-au-myfile.png\" sizes=\"auto, \" srcset=\"\" alt=\"assign the path to the myfile\" width=\"516\" height=\"239\"><\/li><li> Terakhir, gunakan metode \u201cDeleteFile\u201d (lihat ini) untuk menghapus file. <br><img loading=\"lazy\" decoding=\"async\" title=\"6-gunakan-hapus-file-metode\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-utiliser-la-methode-de-suppression-de-fichier.png\" sizes=\"auto, \" srcset=\"\" alt=\"use the delete file method\" width=\"513\" height=\"315\"><\/li><\/ul><p> <strong>Kode lengkap<\/strong><\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_delete_file() Dim FSO Dim myFile As String Set FSO = CreateObject(\"Scripting.FileSystemObject\") myFile = \"C:UsersDellDesktopSample Datafile1.xlsx\" FSO.DeleteFile myFile, True End Sub<\/code><\/pre><p> Katakanlah Anda perlu menulis beberapa kode yang dapat memeriksa suatu file (ada atau tidak) dan kemudian menghapusnya. Ini kode yang Anda butuhkan.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_delete_file() Dim FSO Dim myFile As String Set FSO = CreateObject(\"Scripting.FileSystemObject\") myFile = \"C:UsersDellDesktopSample Datafile1.xlsx\" If FSO.FileExists(myFile) Then FSO.DeleteFile myFile, True MsgBox \"Deleted\" Else MsgBox \"There's no workbook with this name.\" End If End Sub<\/code><\/pre><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/vba\/\">Apa itu VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/salin-file-excelnya\/\">Salin file Excel (buku kerja) menggunakan VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/\">Buku Kerja Aktifkan VBA (File Excel)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tutup-buku-kerja\/\">Tutup buku kerja VBA (file Excel)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menggabungkan-buku-kerja\/\">VBA Menggabungkan Buku Kerja (File Excel)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/membuat-buku-kerja\/\">VBA Buat buku kerja baru (file Excel)<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1545","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bagaimana cara menghapus file menggunakan VBA di Excel?<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus buku kerja menggunakan kode VBA. Ini mencakup dua metode berbeda.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/menghapus-berkas\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menghapus file menggunakan VBA di Excel?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus buku kerja menggunakan kode VBA. Ini mencakup dua metode berbeda.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/menghapus-berkas\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-un-fichier-en-utilisant-la-fonction-vba-kill.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghapus-berkas\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/menghapus-berkas\/\",\"name\":\"Bagaimana cara menghapus file menggunakan VBA di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghapus-berkas\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghapus-berkas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-un-fichier-en-utilisant-la-fonction-vba-kill.png\",\"datePublished\":\"2023-11-17T11:10:09+00:00\",\"dateModified\":\"2023-12-06T06:19:14+00:00\",\"description\":\"Tutorial ini menjelaskan cara menghapus buku kerja menggunakan kode VBA. Ini mencakup dua metode berbeda.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghapus-berkas\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/menghapus-berkas\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghapus-berkas\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-un-fichier-en-utilisant-la-fonction-vba-kill.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-un-fichier-en-utilisant-la-fonction-vba-kill.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghapus-berkas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menghapus file menggunakan vba di excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara menghapus file menggunakan VBA di Excel?","description":"Tutorial ini menjelaskan cara menghapus buku kerja menggunakan kode VBA. Ini mencakup dua metode berbeda.","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:\/\/exceladvisor.org\/id\/menghapus-berkas\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menghapus file menggunakan VBA di Excel?","og_description":"Tutorial ini menjelaskan cara menghapus buku kerja menggunakan kode VBA. Ini mencakup dua metode berbeda.","og_url":"https:\/\/exceladvisor.org\/id\/menghapus-berkas\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:14+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-un-fichier-en-utilisant-la-fonction-vba-kill.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/menghapus-berkas\/","url":"https:\/\/exceladvisor.org\/id\/menghapus-berkas\/","name":"Bagaimana cara menghapus file menggunakan VBA di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/menghapus-berkas\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/menghapus-berkas\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-un-fichier-en-utilisant-la-fonction-vba-kill.png","datePublished":"2023-11-17T11:10:09+00:00","dateModified":"2023-12-06T06:19:14+00:00","description":"Tutorial ini menjelaskan cara menghapus buku kerja menggunakan kode VBA. Ini mencakup dua metode berbeda.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/menghapus-berkas\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/menghapus-berkas\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/menghapus-berkas\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-un-fichier-en-utilisant-la-fonction-vba-kill.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-un-fichier-en-utilisant-la-fonction-vba-kill.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/menghapus-berkas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menghapus file menggunakan vba di excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1545","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1545"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1545\/revisions"}],"predecessor-version":[{"id":2827,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1545\/revisions\/2827"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1545"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}