{"id":1568,"date":"2023-11-16T23:09:10","date_gmt":"2023-11-16T23:09:10","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/salin-file-excelnya\/"},"modified":"2023-12-06T06:18:56","modified_gmt":"2023-12-06T06:18:56","slug":"salin-file-excelnya","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/salin-file-excelnya\/","title":{"rendered":"Bagaimana cara menyalin file excel menggunakan vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2198386685\"><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>Anda bisa menggunakan kode VBA untuk menyalin file (workbook) dari satu folder ke folder lain atau Anda juga bisa menyalin file ke folder yang sama menggunakan nama yang berbeda.<\/p><p> Dalam tutorial ini, kita akan melihat cara menulis kode dua arah. Di sini Anda perlu menggunakan <strong>FileSystemObject<\/strong> yang menyediakan akses ke file dan folder di Windows.<\/p><h2 class=\"wp-block-heading\"> Salin file Excel ke folder terpisah<\/h2><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\"><strong>Sub<\/strong> myMacro() <strong>Dim<\/strong> myFile <strong>As<\/strong> Object <strong>Set<\/strong> myFile = CreateObject(\"Scripting.FileSystemObject\") <strong>Call<\/strong> myFile.CopyFile(\"C:\\Users\\admin\\Desktop\\folder\\test-file.xlsx\", \"C:\\Users\\admin\\Desktop\\\", True) <strong>End<\/strong> <strong>Sub<\/strong><\/code><\/pre><p> Untuk menulis kode di atas: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-12964\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/copier-un-fichier-excel-dans-un-dossier.png\" alt=\"salin-file-excel-ke-folder\" width=\"583\" height=\"267\" srcset=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/copier-un-fichier-excel-dans-un-dossier.png 1216w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/copier-un-fichier-excel-dans-un-dossier-300x137.png 300w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/copier-un-fichier-excel-dans-un-dossier-1024x469.png 1024w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/copier-un-fichier-excel-dans-un-dossier-768x352.png 768w\" sizes=\"auto, (max-width: 583px) 100vw, 583px\"><\/figure><\/div><ol type=\"1\"><li> Pertama, Anda perlu mendeklarasikan variabel.<\/li><li> Selanjutnya, Anda perlu menentukan FileSystemObject ke variabel yang baru saja Anda tentukan.<\/li><li> Selanjutnya, Anda perlu mengatur lokasi sumber dalam metode \u201cCopyFile\u201d.<\/li><li> Terakhir, atur lokasi folder tempat Anda ingin menempelkannya.<\/li><\/ol><p> Saat Anda <a href=\"https:\/\/exceladvisor.org\/id\/jalankan-makro-2\/\">menjalankan makro ini<\/a> , makro ini akan menyalin &#8220;file teks&#8221; buku kerja Excel dari folder dan menempelkannya ke lokasi yang kami tentukan dalam kode. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-61234\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-2-specifier-lobjet-systeme-de-fichiers.png\" sizes=\"auto, \" srcset=\"\" alt=\"tentukan-file-sistem-objek\" width=\"475\" height=\"309\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Salin file dan ganti namanya<\/h2><p> Saat Anda mencoba menyalin dan menempelkan file di lokasi yang sama, ada kemungkinan besar VBA akan menunjukkan kesalahan kepada Anda. Dalam situasi ini, cara terbaik adalah mengganti nama file saat menyalinnya.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Call myFile.CopyFile(\"C:\\Users\\admin\\Desktop\\folder\\test-file.xlsx\", \"C:\\Users\\admin\\Desktop\\\", True)<\/code><\/pre><p> Di atas adalah kode baris yang saya gunakan pada metode sebelumnya. Sekarang Anda hanya perlu melakukan perubahan pada baris ini. Untuk lokasi tujuan, Anda perlu menambahkan file yang ingin Anda gunakan untuk file baru.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Call myFile.CopyFile(\"C:\\Users\\admin\\Desktop\\folder\\test-file.xlsx\", \"C:\\Users\\admin\\Desktop\\folder\\test-file1.xlsx \", True)<\/code><\/pre><p> Saat Anda menjalankan kode ini, kode ini akan menyalin file (file-teks.xlsx) dari folder dan menyalinnya ke folder yang sama dengan nama berbeda (file-uji1.xlsx). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-61235\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-3-copier-un-fichier-et-renommer.png\" sizes=\"auto, \" srcset=\"\" alt=\"salin-file-dan-ganti nama\" width=\"359\" height=\"284\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\"><strong>Dim<\/strong> myFile <strong>As<\/strong> Object <strong>Set<\/strong> myFile = _ CreateObject(\"Scripting.FileSystemObject\") <strong>Call<\/strong> myFile.CopyFile(\"C:\\Users\\admin\\Desktop\\folder\\test-file.xlsx\", _ \"C:\\Users\\admin\\Desktop\\folder\\test-file1.xlsx\", True) <strong>End<\/strong> <strong>Sub<\/strong><\/code><\/pre><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\/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><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-1568","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>Bagaimana cara menyalin file Excel menggunakan VBA? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Anda dapat menggunakan kode VBA untuk menyalin file (buku kerja) dari satu folder ke folder lain atau Anda juga dapat menyalin file ke\" \/>\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\/salin-file-excelnya\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menyalin file Excel menggunakan VBA? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Anda dapat menggunakan kode VBA untuk menyalin file (buku kerja) dari satu folder ke folder lain atau Anda juga dapat menyalin file ke\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/salin-file-excelnya\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/copier-un-fichier-excel-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\/salin-file-excelnya\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/salin-file-excelnya\/\",\"name\":\"Bagaimana cara menyalin file Excel menggunakan VBA? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/salin-file-excelnya\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/salin-file-excelnya\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/copier-un-fichier-excel-dans-un-dossier.png\",\"datePublished\":\"2023-11-16T23:09:10+00:00\",\"dateModified\":\"2023-12-06T06:18:56+00:00\",\"description\":\"Anda dapat menggunakan kode VBA untuk menyalin file (buku kerja) dari satu folder ke folder lain atau Anda juga dapat menyalin file ke\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/salin-file-excelnya\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/salin-file-excelnya\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/salin-file-excelnya\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/copier-un-fichier-excel-dans-un-dossier.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/copier-un-fichier-excel-dans-un-dossier.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/salin-file-excelnya\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menyalin file 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":"Bagaimana cara menyalin file Excel menggunakan VBA? (Tutorial 2023)","description":"Anda dapat menggunakan kode VBA untuk menyalin file (buku kerja) dari satu folder ke folder lain atau Anda juga dapat menyalin file ke","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\/salin-file-excelnya\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menyalin file Excel menggunakan VBA? (Tutorial 2023)","og_description":"Anda dapat menggunakan kode VBA untuk menyalin file (buku kerja) dari satu folder ke folder lain atau Anda juga dapat menyalin file ke","og_url":"https:\/\/exceladvisor.org\/id\/salin-file-excelnya\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:56+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/copier-un-fichier-excel-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\/salin-file-excelnya\/","url":"https:\/\/exceladvisor.org\/id\/salin-file-excelnya\/","name":"Bagaimana cara menyalin file Excel menggunakan VBA? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/salin-file-excelnya\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/salin-file-excelnya\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/copier-un-fichier-excel-dans-un-dossier.png","datePublished":"2023-11-16T23:09:10+00:00","dateModified":"2023-12-06T06:18:56+00:00","description":"Anda dapat menggunakan kode VBA untuk menyalin file (buku kerja) dari satu folder ke folder lain atau Anda juga dapat menyalin file ke","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/salin-file-excelnya\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/salin-file-excelnya\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/salin-file-excelnya\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/copier-un-fichier-excel-dans-un-dossier.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/copier-un-fichier-excel-dans-un-dossier.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/salin-file-excelnya\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menyalin file 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\/1568","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=1568"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1568\/revisions"}],"predecessor-version":[{"id":2788,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1568\/revisions\/2788"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1568"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}