{"id":1546,"date":"2023-11-17T10:49:24","date_gmt":"2023-11-17T10:49:24","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/menggabungkan-buku-kerja\/"},"modified":"2023-12-06T06:16:07","modified_gmt":"2023-12-06T06:16:07","slug":"menggabungkan-buku-kerja","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/menggabungkan-buku-kerja\/","title":{"rendered":"Bagaimana cara menggabungkan beberapa buku kerja excel menggunakan vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-860390073\"><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 menggabungkan beberapa buku kerja Excel, Anda perlu menggunakan beberapa kode yang memungkinkan Anda memilih file mana yang ingin Anda gabungkan atau Anda bisa merujuk ke lokasi jalur tertentu dan menggabungkan semua file Excel di buku kerja saat ini.<\/p><h2 class=\"wp-block-heading\"> VBA menggabungkan beberapa buku kerja<\/h2><p> Anda dapat menggunakan kode berikut yang menggunakan lokasi yang saya sebutkan di variabel path (folder di desktop sistem saya).<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim Path As String Dim Filename As String Dim Sheet As Worksheet Path = \"C:UsersDellDesktopsample-data\" Filename = Dir(Path &amp; \"*.xlsx\") Do While Filename &lt;&gt; \"\" Workbooks.Open Filename:=Path &amp; Filename, ReadOnly:=True For Each Sheet In ActiveWorkbook.Sheets Sheet.Copy After:=ThisWorkbook.Sheets(1) Next Sheet Workbooks(Filename).Close Filename = Dir() Loop<\/code><\/pre><h2 class=\"wp-block-heading\"> Langkah-langkah Menggabungkan File Excel Menggunakan VBA<\/h2><ol><li> Buka Visual Basic Editor (pastikan untuk mengaktifkan tab Pengembang jika Anda sudah memilikinya di Ribbon). <br><img loading=\"lazy\" decoding=\"async\" title=\"1-editor-visual-dasar-terbuka\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ouvrir-lediteur-de-base-visuel.png\" sizes=\"auto, \" srcset=\"\" alt=\"open the visual basic editor\" width=\"591\" height=\"138\"><\/li><li> Setelah itu, cari buku kerja saat ini dari jendela proyek (control + r) dan masukkan modul baru ke dalamnya. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-temukan-buku kerja-saat ini\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-localiser-le-classeur-en-cours.png\" sizes=\"auto, \" srcset=\"\" alt=\"locate the current workbook\" width=\"454\" height=\"379\"><\/li><li> Anda akan memiliki jendela kode di modul (klik dua kali di atasnya) di mana Anda perlu menempelkan kode yang Anda miliki (sebagaimana adanya). <br><img loading=\"lazy\" decoding=\"async\" title=\"Jendela 3 kode dalam modul\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-fenetre-de-code-dans-le-module.png\" sizes=\"auto, \" srcset=\"\" alt=\"code window in the module\" width=\"634\" height=\"227\"><\/li><li> Dari sini, Anda perlu mengubah nilai variabel jalur dengan lokasi folder tempat semua file Excel yang ingin Anda gabungkan berada. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-perubahan-nilai-variabel-jalur\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-modifier-la-valeur-de-la-variable-de-chemin.png\" sizes=\"auto, \" srcset=\"\" alt=\"change the value for the path variable\" width=\"479\" height=\"369\"><\/li><li> Pada akhirnya, jalankan kode dan Anda mendapatkan semua lembar kerja di buku kerja di file saat ini.<\/li><\/ol><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><p> Kode ini membuka setiap file satu per satu dan menyalin setiap lembar kerja satu per satu dan menempelkannya ke file saat ini dengan nama yang sama. Ini adalah kode yang sama tetapi dengan layar diperbarui ke false di awal untuk menjalankan semuanya di backend.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim Path As String Dim Filename As String Dim Sheet As Worksheet Application.ScreenUpdating = False Path = \"C:UsersDellDesktopsample-data\" Filename = Dir(Path &amp; \"*.xlsx\") Do While Filename &lt;&gt; \"\" Workbooks.Open Filename:=Path &amp; Filename, ReadOnly:=True For Each Sheet In ActiveWorkbook.Sheets Sheet.Copy After:=ThisWorkbook.Sheets(1) Next Sheet Workbooks(Filename).Close Filename = Dir() Loop Application.ScreenUpdating = True End Sub<\/code><\/pre><p class=\"qt-tip\"> <strong>Catatan:<\/strong> Jika Anda ingin mempelajari cara menggabungkan data dari beberapa buku kerja ke dalam satu tabel, pastikan untuk membaca panduan ini.<\/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\/membuat-buku-kerja\/\">VBA Buat buku kerja baru (file Excel)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghapus-berkas\/\">VBA Hapus Buku Kerja (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-1546","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>\u25b7 Bagaimana cara menggabungkan beberapa buku kerja Excel melalui VBA?<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan VBA untuk menggabungkan beberapa file Excel menjadi satu.\" \/>\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\/menggabungkan-buku-kerja\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara menggabungkan beberapa buku kerja Excel melalui VBA?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan VBA untuk menggabungkan beberapa file Excel menjadi satu.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/menggabungkan-buku-kerja\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:16:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ouvrir-lediteur-de-base-visuel.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\/menggabungkan-buku-kerja\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/menggabungkan-buku-kerja\/\",\"name\":\"\u25b7 Bagaimana cara menggabungkan beberapa buku kerja Excel melalui VBA?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menggabungkan-buku-kerja\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menggabungkan-buku-kerja\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ouvrir-lediteur-de-base-visuel.png\",\"datePublished\":\"2023-11-17T10:49:24+00:00\",\"dateModified\":\"2023-12-06T06:16:07+00:00\",\"description\":\"Tutorial ini menjelaskan cara menggunakan VBA untuk menggabungkan beberapa file Excel menjadi satu.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menggabungkan-buku-kerja\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/menggabungkan-buku-kerja\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menggabungkan-buku-kerja\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ouvrir-lediteur-de-base-visuel.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ouvrir-lediteur-de-base-visuel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menggabungkan-buku-kerja\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggabungkan beberapa buku kerja excel menggunakan vba?\"}]},{\"@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":"\u25b7 Bagaimana cara menggabungkan beberapa buku kerja Excel melalui VBA?","description":"Tutorial ini menjelaskan cara menggunakan VBA untuk menggabungkan beberapa file Excel menjadi satu.","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\/menggabungkan-buku-kerja\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menggabungkan beberapa buku kerja Excel melalui VBA?","og_description":"Tutorial ini menjelaskan cara menggunakan VBA untuk menggabungkan beberapa file Excel menjadi satu.","og_url":"https:\/\/exceladvisor.org\/id\/menggabungkan-buku-kerja\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:16:07+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ouvrir-lediteur-de-base-visuel.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\/menggabungkan-buku-kerja\/","url":"https:\/\/exceladvisor.org\/id\/menggabungkan-buku-kerja\/","name":"\u25b7 Bagaimana cara menggabungkan beberapa buku kerja Excel melalui VBA?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/menggabungkan-buku-kerja\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/menggabungkan-buku-kerja\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ouvrir-lediteur-de-base-visuel.png","datePublished":"2023-11-17T10:49:24+00:00","dateModified":"2023-12-06T06:16:07+00:00","description":"Tutorial ini menjelaskan cara menggunakan VBA untuk menggabungkan beberapa file Excel menjadi satu.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/menggabungkan-buku-kerja\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/menggabungkan-buku-kerja\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/menggabungkan-buku-kerja\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ouvrir-lediteur-de-base-visuel.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ouvrir-lediteur-de-base-visuel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/menggabungkan-buku-kerja\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggabungkan beberapa buku kerja excel menggunakan vba?"}]},{"@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\/1546","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=1546"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1546\/revisions"}],"predecessor-version":[{"id":2495,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1546\/revisions\/2495"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1546"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}