{"id":1543,"date":"2023-11-17T11:32:12","date_gmt":"2023-11-17T11:32:12","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/periksa-apakah-buku-kerja-itu-ada\/"},"modified":"2023-12-06T06:14:16","modified_gmt":"2023-12-06T06:14:16","slug":"periksa-apakah-buku-kerja-itu-ada","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/periksa-apakah-buku-kerja-itu-ada\/","title":{"rendered":"Bagaimana cara memeriksa apakah buku kerja ada di folder?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2796168687\"><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 memeriksa apakah buku kerja ada di folder tertentu, Anda bisa menggunakan fungsi DIR. DIR adalah fungsi yang mewakili direktori. Anda perlu menentukan jalur file dengan nama dan ekstensi. Jika file ada, ia mengembalikan nama file, jika tidak, nilai kosong.<\/p><h2 class=\"wp-block-heading\"> Tulis kode untuk memeriksa apakah file Excel ada di folder<\/h2><p> Gunakan langkah-langkah berikut: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53073\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-code-pour-verifier-si-un-fichier-excel-existe-dans-un-dossier.png\" sizes=\"auto, \" srcset=\"\" alt=\"kode untuk memeriksa apakah ada file excel di dalam folder\" width=\"539\" height=\"183\"><\/figure><\/div><ol type=\"1\"><li> Pertama, <a href=\"https:\/\/exceladvisor.org\/id\/rentang-1\/\">tentukan rentang<\/a> atau <a href=\"https:\/\/exceladvisor.org\/id\/kotak-pesan-vba\/\">kotak pesan<\/a> untuk mendapatkan hasil fungsi.<\/li><li> Sekarang masukkan nama fungsi \u201cDIR\u201d dan ketik tanda kurung di depannya.<\/li><li> Setelah itu, masukkan path file menggunakan tanda kutip ganda dan pastikan untuk memasukkan ekstensi file beserta nama file.<\/li><li> Selanjutnya, ketikkan tanda kurung tutup untuk menutup baris kode.<\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_Check_workbook() MsgBox Dir(\"C:UsersDellDesktopbook1.xlsx\") End Sub<\/code><\/pre><p> Saat Anda menjalankan baris kode ini, kotak pesan muncul berisi nama file, yang berarti file tersebut ada di lokasi yang Anda tentukan.<\/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\"> Temukan banyak file jika ada dalam satu folder<\/h2><p> Anda mungkin perlu memeriksa beberapa file jika semuanya ada dalam satu folder. Dalam hal ini Anda dapat menggunakan kode berikut. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_check_workbook() Dim myFolder As String Dim myFileName As String Dim myRange As Range Dim myCell As Range Set myRange = Range(\"A1:A5\") myFolder = \"C:UsersDellDesktopData\" For Each myCell In myRange myFileName = myCell.Value If Dir(myFolder &amp; \"\" &amp; myFileName) = \"\" Then myCell.Offset(0, 1) = \"File Doesn't Exists.\" Else myCell.Offset(0, 1) = \"File Exists\" End If Next myCell End Sub<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53074\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-fichiers-multiples-sils-existent-dans-un-dossier.png\" sizes=\"auto, \" srcset=\"\" alt=\"beberapa file jika ada dalam satu folder\" width=\"593\" height=\"526\"><\/figure><\/div><p> Untuk memahami kode ini, saya membaginya menjadi tiga bagian.<\/p><ul><li> Di bagian PERTAMA Anda memiliki semua variabel yang perlu kita gunakan dalam kode. Variabel untuk digunakan sebagai alamat folder, nama file, rentang tempat Anda memiliki semua nama dan setiap sel dalam rentang tersebut.<\/li><li> Di bagian KEDUA, Anda menentukan rentang alamat tempat Anda memiliki semua nama file yang ingin Anda periksa. Dan juga jalur folder yang ditetapkan ke variabel.<\/li><li> Di bagian KETIGA Anda memiliki <a href=\"https:\/\/exceladvisor.org\/id\/untuk-lingkaran\/\">LOOP FOR EACH<\/a> untuk menelusuri semua file dalam folder. Perulangan ini menggunakan DIR untuk mencocokkan semua nama yang Anda miliki dalam rentang tersebut. Ia juga menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/jika-2\/\">PERNYATAAN IF<\/a> untuk memasukkan nilai pada sel terkait sebagai keterangan apakah file tersebut ada atau tidak.<\/li><\/ul><p class=\"qt-tip\"> <strong>Catatan:<\/strong> Jika Anda ingin menggunakan kode ini, Anda perlu mengubah jalur folder dan Anda perlu mengatur rentang di mana Anda memiliki semua nama buku kerja.<\/p><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-1543","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>VBA: Bagaimana cara memeriksa apakah buku kerja ada di folder?<\/title>\n<meta name=\"description\" content=\"Tutorial ini membantu Anda mempelajari cara menggunakan VBA untuk membuka buku kerja Excel yang disimpan dalam folder di sistem Anda.\" \/>\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\/periksa-apakah-buku-kerja-itu-ada\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Bagaimana cara memeriksa apakah buku kerja ada di folder?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini membantu Anda mempelajari cara menggunakan VBA untuk membuka buku kerja Excel yang disimpan dalam folder di sistem Anda.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/periksa-apakah-buku-kerja-itu-ada\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:14:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-code-pour-verifier-si-un-fichier-excel-existe-dans-un-dossier.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\/periksa-apakah-buku-kerja-itu-ada\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/periksa-apakah-buku-kerja-itu-ada\/\",\"name\":\"VBA: Bagaimana cara memeriksa apakah buku kerja ada di folder?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/periksa-apakah-buku-kerja-itu-ada\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/periksa-apakah-buku-kerja-itu-ada\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-code-pour-verifier-si-un-fichier-excel-existe-dans-un-dossier.png\",\"datePublished\":\"2023-11-17T11:32:12+00:00\",\"dateModified\":\"2023-12-06T06:14:16+00:00\",\"description\":\"Tutorial ini membantu Anda mempelajari cara menggunakan VBA untuk membuka buku kerja Excel yang disimpan dalam folder di sistem Anda.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/periksa-apakah-buku-kerja-itu-ada\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/periksa-apakah-buku-kerja-itu-ada\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/periksa-apakah-buku-kerja-itu-ada\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-code-pour-verifier-si-un-fichier-excel-existe-dans-un-dossier.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-code-pour-verifier-si-un-fichier-excel-existe-dans-un-dossier.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/periksa-apakah-buku-kerja-itu-ada\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara memeriksa apakah buku kerja ada di folder?\"}]},{\"@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":"VBA: Bagaimana cara memeriksa apakah buku kerja ada di folder?","description":"Tutorial ini membantu Anda mempelajari cara menggunakan VBA untuk membuka buku kerja Excel yang disimpan dalam folder di sistem Anda.","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\/periksa-apakah-buku-kerja-itu-ada\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Bagaimana cara memeriksa apakah buku kerja ada di folder?","og_description":"Tutorial ini membantu Anda mempelajari cara menggunakan VBA untuk membuka buku kerja Excel yang disimpan dalam folder di sistem Anda.","og_url":"https:\/\/exceladvisor.org\/id\/periksa-apakah-buku-kerja-itu-ada\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:14:16+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-code-pour-verifier-si-un-fichier-excel-existe-dans-un-dossier.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\/periksa-apakah-buku-kerja-itu-ada\/","url":"https:\/\/exceladvisor.org\/id\/periksa-apakah-buku-kerja-itu-ada\/","name":"VBA: Bagaimana cara memeriksa apakah buku kerja ada di folder?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/periksa-apakah-buku-kerja-itu-ada\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/periksa-apakah-buku-kerja-itu-ada\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-code-pour-verifier-si-un-fichier-excel-existe-dans-un-dossier.png","datePublished":"2023-11-17T11:32:12+00:00","dateModified":"2023-12-06T06:14:16+00:00","description":"Tutorial ini membantu Anda mempelajari cara menggunakan VBA untuk membuka buku kerja Excel yang disimpan dalam folder di sistem Anda.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/periksa-apakah-buku-kerja-itu-ada\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/periksa-apakah-buku-kerja-itu-ada\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/periksa-apakah-buku-kerja-itu-ada\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-code-pour-verifier-si-un-fichier-excel-existe-dans-un-dossier.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-code-pour-verifier-si-un-fichier-excel-existe-dans-un-dossier.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/periksa-apakah-buku-kerja-itu-ada\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara memeriksa apakah buku kerja ada di folder?"}]},{"@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\/1543","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=1543"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1543\/revisions"}],"predecessor-version":[{"id":2341,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1543\/revisions\/2341"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}