{"id":4993,"date":"2023-07-05T10:35:18","date_gmt":"2023-07-05T10:35:18","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-buka-semua-file-di-folder\/"},"modified":"2023-07-05T10:35:18","modified_gmt":"2023-07-05T10:35:18","slug":"vba-buka-semua-file-di-folder","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-buka-semua-file-di-folder\/","title":{"rendered":"Vba: cara membuka semua file dalam folder"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan loop <strong>Do While<\/strong> dengan metode <strong>Workbooks.Open<\/strong> di VBA untuk membuka semua file di folder tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Berikut adalah cara umum untuk melakukan hal ini dalam praktik:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> OpenAllFilesInFolder()\n\n<span style=\"color: #0000ff;\">Dim<\/span> ThisFolder <span style=\"color: #0000ff;\">As String<\/span>\n<span style=\"color: #0000ff;\">Dim<\/span> ThisFile <span style=\"color: #0000ff;\">As String<\/span>\n\n<span style=\"color: #008000;\">'specify folder location and types of files to open in folder\n<\/span>ThisFolder = \"C:\\Users\\bob\\Documents\\current_data\"\nThisFile = Dir(ThisFolder &amp; \"\\*.xlsx\")\n\n<span style=\"color: #008000;\">'open each xlsx file in folder\n<\/span><span style=\"color: #0000ff;\">Do While<\/span> ThisFile &lt;&gt; \"\"\n    Workbooks.Open Filename:=ThisFolder &amp; \"\\\" &amp; ThisFile\n    ThisFile = Dir\n<span style=\"color: #0000ff;\">Loop<\/span>\n\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini membuka semua file dengan ekstensi <strong>.xlsx<\/strong> di folder berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>C:\\Users\\bob\\Documents\\current_data<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan makro ini dalam praktiknya.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong> <a href=\"https:\/\/statorials.org\/id\/vba-dapatkan-daftar-buku-kerja-yang-terbuka\/\" target=\"_blank\" rel=\"noopener\">Cara Mendapatkan Daftar Semua Buku Kerja Terbuka Menggunakan VBA<\/a><\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara membuka semua file dalam satu folder menggunakan VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki folder berikut bernama <strong>current_data<\/strong> yang berisi tiga file <strong>.xlsx<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38950 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/oa1.png\" alt=\"\" width=\"557\" height=\"333\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin menggunakan VBA untuk membuka semua file <strong>.xlsx<\/strong> di folder ini.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> OpenAllFilesInFolder()\n\n<span style=\"color: #0000ff;\">Dim<\/span> ThisFolder <span style=\"color: #0000ff;\">As String<\/span>\n<span style=\"color: #0000ff;\">Dim<\/span> ThisFile <span style=\"color: #0000ff;\">As String<\/span>\n\n<span style=\"color: #008000;\">'specify folder location and types of files to open in folder\n<\/span>ThisFolder = \"C:\\Users\\bob\\Documents\\current_data\"\nThisFile = Dir(ThisFolder &amp; \"\\*.xlsx\")\n\n<span style=\"color: #008000;\">'open each xlsx file in folder\n<\/span><span style=\"color: #0000ff;\">Do While<\/span> ThisFile &lt;&gt; \"\"\n    Workbooks.Open Filename:=ThisFolder &amp; \"\\\" &amp; ThisFile\n    ThisFile = Dir\n<span style=\"color: #0000ff;\">Loop<\/span>\n\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kita menjalankan makro ini, setiap file berekstensi <strong>.xlsx<\/strong> yang ada di folder tersebut akan dibuka satu per satu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa jika salah satu file dalam folder tersebut sudah terbuka, file tersebut akan tetap terbuka.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk metode <strong>Workbooks.Open<\/strong> di VBA <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/excel.workbooks.open\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/vba-mengganti-nama-file\/\" target=\"_blank\" rel=\"noopener\">Cara mengganti nama file menggunakan VBA<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-daftar-file-dalam-folder\/\">Cara membuat daftar file dalam folder menggunakan VBA<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-memeriksa-apakah-file-ada\/\" target=\"_blank\" rel=\"noopener\">Cara memeriksa apakah file ada menggunakan VBA<\/a><br \/><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan loop Do While dengan metode Workbooks.Open di VBA untuk membuka semua file di folder tertentu. Berikut adalah cara umum untuk melakukan hal ini dalam praktik: Sub OpenAllFilesInFolder() Dim ThisFolder As String Dim ThisFile As String &#8216;specify folder location and types of files to open in folder ThisFolder = &#8220;C:\\Users\\bob\\Documents\\current_data&#8221; ThisFile = Dir(ThisFolder [&hellip;]<\/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":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>VBA: Cara membuka semua file dalam satu folder - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan VBA untuk membuka semua file dalam folder tertentu, dengan sebuah 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\/vba-buka-semua-file-di-folder\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara membuka semua file dalam satu folder - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan VBA untuk membuka semua file dalam folder tertentu, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-buka-semua-file-di-folder\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-05T10:35:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/oa1.png\" \/>\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\/vba-buka-semua-file-di-folder\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-buka-semua-file-di-folder\/\",\"name\":\"VBA: Cara membuka semua file dalam satu folder - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-05T10:35:18+00:00\",\"dateModified\":\"2023-07-05T10:35:18+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan VBA untuk membuka semua file dalam folder tertentu, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-buka-semua-file-di-folder\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-buka-semua-file-di-folder\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-buka-semua-file-di-folder\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara membuka semua file dalam folder\"}]},{\"@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":"VBA: Cara membuka semua file dalam satu folder - Statologi","description":"Tutorial ini menjelaskan cara menggunakan VBA untuk membuka semua file dalam folder tertentu, dengan sebuah 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\/vba-buka-semua-file-di-folder\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara membuka semua file dalam satu folder - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan VBA untuk membuka semua file dalam folder tertentu, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/vba-buka-semua-file-di-folder\/","og_site_name":"Statorials","article_published_time":"2023-07-05T10:35:18+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/oa1.png"}],"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\/vba-buka-semua-file-di-folder\/","url":"https:\/\/statorials.org\/id\/vba-buka-semua-file-di-folder\/","name":"VBA: Cara membuka semua file dalam satu folder - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-05T10:35:18+00:00","dateModified":"2023-07-05T10:35:18+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan VBA untuk membuka semua file dalam folder tertentu, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-buka-semua-file-di-folder\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-buka-semua-file-di-folder\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-buka-semua-file-di-folder\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara membuka semua file dalam folder"}]},{"@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\/4993"}],"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=4993"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4993\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4993"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4993"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4993"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}