{"id":4946,"date":"2023-07-06T02:10:18","date_gmt":"2023-07-06T02:10:18","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-memindahkan-file\/"},"modified":"2023-07-06T02:10:18","modified_gmt":"2023-07-06T02:10:18","slug":"vba-memindahkan-file","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-memindahkan-file\/","title":{"rendered":"Cara memindahkan file menggunakan vba (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode <b>MoveFile<\/b> di VBA untuk memindahkan file dari satu folder ke folder 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> MoveMyFile()\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 = <span style=\"color: #000000;\">CreateObject(\"Scripting.FileSystemObject\")<\/span>\n    \n<span style=\"color: #0000ff;\"><span style=\"color: #000000;\"><span style=\"color: #008000;\">'specify source file and destination file<\/span>\nSourceFile = \"C:\\Users\\bob\\Desktop\\Some_Data_1\\soccer_data.txt\"\nDestFile = \"C:\\Users\\bob\\Desktop\\Some_Data_2\\soccer_data.txt\"\n\n<span style=\"color: #008000;\">'move file<\/span>\nFSO.MoveFile Source:=SourceFile, Destination:=DestFile\n<\/span>\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini memindahkan file bernama <strong>Soccer_data.txt<\/strong> dari folder bernama <strong>Some_Data_1<\/strong> ke folder bernama <strong>Some_Data_2<\/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 memindahkan file menggunakan VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki file teks bernama <strong>football_data.txt<\/strong> yang terletak di folder bernama <strong>Some_Data_1<\/strong> di desktop kita:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38620 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/movefile1.png\" alt=\"\" width=\"601\" height=\"352\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang katakanlah kita ingin menggunakan VBA untuk memindahkan file teks ini ke folder lain bernama <strong>Some_Data_2<\/strong> di desktop kita, yang saat ini berisi dua file teks:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38621 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/movefile2.png\" alt=\"\" width=\"605\" height=\"351\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sebelum menggunakan VBA untuk memindahkan 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 memindahkan file:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> MoveMyFile()\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 file and destination file<\/span>\n<span style=\"color: #000000;\">SourceFile = \"C:\\Users\\bob\\Desktop\\Some_Data_1\\soccer_data.txt\"\nDestFile = \"C:\\Users\\bob\\Desktop\\Some_Data_2\\soccer_data.txt\"\n\n<span style=\"color: #008000;\">'move file\n<\/span>FSO.MoveFile Source:=SourceFile, Destination:=DestFile<\/span>\n\nEnd Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Setelah makro ini dijalankan, file bernama <strong>football_data.txt<\/strong> akan dipindahkan dari folder <strong>Some_Data_1<\/strong> ke folder <strong>Some_Data_2<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38622 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/movefile3.png\" alt=\"\" width=\"564\" height=\"341\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Perhatikan bahwa jika Anda ingin memindahkan semua file dari satu folder ke folder lain, Anda dapat menggunakan sintaks berikut:<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> MoveMyFile()\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 and destination folders<\/span>\n<span style=\"color: #000000;\">SourceFile = \"C:\\Users\\bob\\Desktop\\Some_Data_1\\*\"\nDestFile = \"C:\\Users\\bob\\Desktop\\Some_Data_2\\\"<\/span>\n\n<span style=\"color: #008000;\">'move all files from source folder to destination folder\n<\/span><span style=\"color: #000000;\">FSO.MoveFile Source:=SourceFile, Destination:=DestFile\n<\/span>\nEnd Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini akan memindahkan semua file dari folder <strong>Some_Data_1<\/strong> ke folder <strong>Some_Data_2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk metode <b>MoveFile<\/b> <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/movefile-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\/hapus-file-vba\/\" target=\"_blank\" rel=\"noopener\">Cara menghapus file menggunakan VBA<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode MoveFile di VBA untuk memindahkan file dari satu folder ke folder lain. Berikut adalah cara umum untuk menggunakan metode ini dalam praktik: Sub MoveMyFile() Dim FSO As New FileSystemObject Set FSO = CreateObject(&#8220;Scripting.FileSystemObject&#8221;) &#8216;specify source file and destination file SourceFile = &#8220;C:\\Users\\bob\\Desktop\\Some_Data_1\\soccer_data.txt&#8221; DestFile = &#8220;C:\\Users\\bob\\Desktop\\Some_Data_2\\soccer_data.txt&#8221; &#8216;move file FSO.MoveFile Source:=SourceFile, Destination:=DestFile 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 Memindahkan File Menggunakan VBA (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memindahkan file Excel menggunakan VBA, beserta contohnya.\" \/>\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-memindahkan-file\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Memindahkan File Menggunakan VBA (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memindahkan file Excel menggunakan VBA, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-memindahkan-file\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T02:10:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/movefile1.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-memindahkan-file\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-memindahkan-file\/\",\"name\":\"Cara Memindahkan File Menggunakan VBA (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T02:10:18+00:00\",\"dateModified\":\"2023-07-06T02:10:18+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memindahkan file Excel menggunakan VBA, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-memindahkan-file\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-memindahkan-file\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-memindahkan-file\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara memindahkan file menggunakan 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 Memindahkan File Menggunakan VBA (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara memindahkan file Excel menggunakan VBA, beserta contohnya.","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-memindahkan-file\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Memindahkan File Menggunakan VBA (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara memindahkan file Excel menggunakan VBA, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/vba-memindahkan-file\/","og_site_name":"Statorials","article_published_time":"2023-07-06T02:10:18+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/movefile1.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-memindahkan-file\/","url":"https:\/\/statorials.org\/id\/vba-memindahkan-file\/","name":"Cara Memindahkan File Menggunakan VBA (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T02:10:18+00:00","dateModified":"2023-07-06T02:10:18+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memindahkan file Excel menggunakan VBA, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-memindahkan-file\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-memindahkan-file\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-memindahkan-file\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara memindahkan file menggunakan 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\/4946"}],"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=4946"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4946\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4946"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4946"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4946"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}