{"id":4996,"date":"2023-07-05T09:35:13","date_gmt":"2023-07-05T09:35:13","guid":{"rendered":"https:\/\/statorials.org\/id\/folder-salinan-vba\/"},"modified":"2023-07-05T09:35:13","modified_gmt":"2023-07-05T09:35:13","slug":"folder-salinan-vba","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/folder-salinan-vba\/","title":{"rendered":"Cara menyalin folder di vba (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode <b>CopyFolder<\/b> di VBA untuk menyalin folder dari satu lokasi ke lokasi lain.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Berikut adalah cara umum untuk menggunakan metode 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> CopyMyFolder()\n\n<span style=\"color: #0000ff;\">Dim<\/span> FSO <span style=\"color: #0000ff;\">As<\/span> New FileSystemObject\n<span style=\"color: #0000ff;\">Set<\/span> FSO = CreateObject(\"Scripting.FileSystemObject\")\n    \n<span style=\"color: #0000ff;\"><span style=\"color: #008000;\">'specify source folder and destination folder<\/span>\n<span style=\"color: #000000;\">SourceFolder = \"C:\\Users\\bob\\Documents\\current_data\"\nDestFolder = \"C:\\Users\\bob\\Desktop\\\"\n\n<span style=\"color: #008000;\">'copy folder\n<\/span>FSO.CopyFolder Source:=SourceFolder, Destination:=DestFolder\n\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/span><\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini menyalin folder bernama <strong>current_data<\/strong> dari folder <strong>Dokumen<\/strong> ke <strong>Desktop<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh : Cara copy folder menggunakan VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki folder bernama <strong>current_data<\/strong> yang terletak di folder bernama <strong>Documents<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38972 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dossier-de-copie0.png\" alt=\"\" width=\"582\" height=\"333\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang katakanlah kita ingin menggunakan VBA untuk menyalin seluruh folder ini ke <strong>Desktop<\/strong> , yang saat ini berisi dua folder:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38973 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dossier-de-copie1.png\" alt=\"\" width=\"533\" height=\"265\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sebelum menggunakan VBA untuk menyalin file ini, kita harus mengaktifkan <strong>Microsoft Scripting Runtime<\/strong> terlebih dahulu di editor VB.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, buka editor VB, lalu klik <strong>Alat<\/strong> , lalu klik <strong>Referensi<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35001 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fichier-t2.png\" alt=\"\" width=\"522\" height=\"336\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, gulir ke bawah hingga Anda melihat <strong>Microsoft Scripting Runtime<\/strong> dan centang kotak di sebelahnya. Lalu klik <strong>oke<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35002 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fichier-t3.png\" alt=\"\" width=\"455\" height=\"379\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian kita bisa membuat makro berikut untuk menyalin folder:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> CopyMyFolder()\n\n<span style=\"color: #0000ff;\">Dim<\/span> FSO <span style=\"color: #0000ff;\">As<\/span> New FileSystemObject\n<span style=\"color: #0000ff;\">Set<\/span> FSO = CreateObject(\"Scripting.FileSystemObject\")\n    \n<span style=\"color: #0000ff;\"><span style=\"color: #008000;\">'specify source folder and destination folder<\/span>\n<span style=\"color: #000000;\">SourceFolder = \"C:\\Users\\bob\\Documents\\current_data\"\nDestFolder = \"C:\\Users\\bob\\Desktop\\\"<\/span>\n\n<span style=\"color: #008000;\">'copy folder\n<\/span><span style=\"color: #000000;\">FSO.CopyFolder Source:=SourceFolder, Destination:=DestFolder\n<\/span>\nEnd Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Setelah makro ini dijalankan, folder bernama <strong>current_data<\/strong> akan disalin dari folder <b>Dokumen<\/b> ke <strong>desktop<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38974 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dossier-de-copie2.png\" alt=\"\" width=\"568\" height=\"334\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Folder <strong>current_data<\/strong> asli juga akan tetap berada di folder <b>Dokumen<\/b> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk metode <b>CopyFolder<\/b> <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/copyfolder-method\" 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-membuat-folder\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Folder Menggunakan VBA<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-hapus-folder\/\" target=\"_blank\" rel=\"noopener\">Cara menghapus folder menggunakan VBA<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-daftar-file-dalam-folder\/\" target=\"_blank\" rel=\"noopener\">Cara membuat daftar file dalam folder menggunakan VBA<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode CopyFolder di VBA untuk menyalin folder dari satu lokasi ke lokasi lain. Berikut adalah cara umum untuk menggunakan metode ini dalam praktik: Sub CopyMyFolder() Dim FSO As New FileSystemObject Set FSO = CreateObject(&#8220;Scripting.FileSystemObject&#8221;) &#8216;specify source folder and destination folder SourceFolder = &#8220;C:\\Users\\bob\\Documents\\current_data&#8221; DestFolder = &#8220;C:\\Users\\bob\\Desktop\\&#8221; &#8216;copy folder FSO.CopyFolder Source:=SourceFolder, Destination:=DestFolder End [&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>Cara Menyalin Folder di VBA (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menyalin folder dari satu tujuan ke tujuan lain menggunakan VBA, beserta 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\/folder-salinan-vba\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menyalin Folder di VBA (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menyalin folder dari satu tujuan ke tujuan lain menggunakan VBA, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/folder-salinan-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-05T09:35:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dossier-de-copie0.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/folder-salinan-vba\/\",\"url\":\"https:\/\/statorials.org\/id\/folder-salinan-vba\/\",\"name\":\"Cara Menyalin Folder di VBA (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-05T09:35:13+00:00\",\"dateModified\":\"2023-07-05T09:35:13+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menyalin folder dari satu tujuan ke tujuan lain menggunakan VBA, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/folder-salinan-vba\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/folder-salinan-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/folder-salinan-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menyalin folder di 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 Menyalin Folder di VBA (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menyalin folder dari satu tujuan ke tujuan lain menggunakan VBA, beserta 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\/folder-salinan-vba\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menyalin Folder di VBA (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menyalin folder dari satu tujuan ke tujuan lain menggunakan VBA, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/folder-salinan-vba\/","og_site_name":"Statorials","article_published_time":"2023-07-05T09:35:13+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dossier-de-copie0.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/folder-salinan-vba\/","url":"https:\/\/statorials.org\/id\/folder-salinan-vba\/","name":"Cara Menyalin Folder di VBA (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-05T09:35:13+00:00","dateModified":"2023-07-05T09:35:13+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menyalin folder dari satu tujuan ke tujuan lain menggunakan VBA, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/folder-salinan-vba\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/folder-salinan-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/folder-salinan-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menyalin folder di 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\/4996"}],"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=4996"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4996\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4996"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4996"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4996"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}