{"id":4469,"date":"2023-07-10T20:54:36","date_gmt":"2023-07-10T20:54:36","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-simpan-sebagai-csv\/"},"modified":"2023-07-10T20:54:36","modified_gmt":"2023-07-10T20:54:36","slug":"vba-simpan-sebagai-csv","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-simpan-sebagai-csv\/","title":{"rendered":"Vba: cara menyimpan spreadsheet sebagai file csv (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda bisa menggunakan sintaks berikut di VBA untuk menyimpan setiap lembar buku kerja ke file CSV:<\/span><\/p>\n

 Sub<\/span> SaveCSV()\n\nDim<\/span> Ws As<\/span> Worksheet\nDim<\/span> SaveDir As<\/span> String\n\nDim<\/span> CurrentWorkbook As<\/span> String\nDim<\/span> CurrentFormat As<\/span> Long\n\nCurrentWorkbook = ThisWorkbook.FullName\nCurrentFormat = ThisWorkbook.FileFormat\n\n'specify directory to save CSV files in\n<\/span>SaveDir = \" C:\\Users\\bobbi\\OneDrive\\Desktop\\<\/span> \"\n\n'save each sheet to individual CSV file\n<\/span>For Each<\/span> Ws In<\/span> Application.ActiveWorkbook.Worksheets\n    Ws.SaveAs SaveDir & Ws.Name, xlCSV\nNext<\/span>\n\nApplication.DisplayAlerts = False\nThisWorkbook.SaveAs Filename:=CurrentWorkbook, FileFormat:=CurrentFormat\nApplication.DisplayAlerts = True\n\nEnd Sub\n<\/span><\/strong><\/span><\/pre>\n
 Makro khusus ini akan menyimpan setiap lembar buku kerja yang sedang aktif ke file CSV.<\/span><\/p>\n
 File CSV akan disimpan di jalur yang ditentukan dalam variabel SaveDir<\/strong> .<\/span><\/p>\n
 Catatan<\/strong> : Baris Application.DisplayAlerts=False<\/strong> memberitahu VBA untuk menonaktifkan sementara semua peringatan tampilan di Excel saat menyimpan file.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Simpan Spreadsheet sebagai File CSV Menggunakan VBA<\/strong><\/span><\/h2>\n
 Misalkan kita memiliki buku kerja Excel dengan dua lembar.<\/span><\/p>\n
 Lembar pertama disebut player_stats<\/strong> dan berisi statistik tentang pemain bola basket yang berbeda:<\/span> <\/p>\n
\"\"<\/p>\n
 Lembar kedua disebut team_info<\/strong> dan berisi informasi tentang berbagai tim bola basket:<\/span> <\/p>\n
\"\"<\/p>\n
 Katakanlah kita ingin menyimpan masing-masing sheet ini sebagai file CSV individual di desktop komputer kita.<\/span><\/p>\n
 Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n
 Sub<\/span> SaveCSV()\n\nDim<\/span> Ws As<\/span> Worksheet\nDim<\/span> SaveDir As<\/span> String\n\nDim<\/span> CurrentWorkbook As<\/span> String\nDim<\/span> CurrentFormat As<\/span> Long\n\nCurrentWorkbook = ThisWorkbook.FullName\nCurrentFormat = ThisWorkbook.FileFormat\n\n'specify directory to save CSV files in\n<\/span>SaveDir = \" C:\\Users\\bobbi\\OneDrive\\Desktop\\<\/span> \"\n\n'save each sheet to individual CSV file\n<\/span>For Each<\/span> Ws In<\/span> Application.ActiveWorkbook.Worksheets\n    Ws.SaveAs SaveDir & Ws.Name, xlCSV\nNext<\/span>\n\nApplication.DisplayAlerts = False\nThisWorkbook.SaveAs Filename:=CurrentWorkbook, FileFormat:=CurrentFormat\nApplication.DisplayAlerts = True\n\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Setelah makro ini dijalankan, setiap lembar akan disimpan sebagai file CSV di desktop kita.<\/span><\/p>\n
 Jika saya menavigasi ke desktop komputer, saya dapat melihat masing-masing file CSV berikut dengan nama file yang cocok dengan nama sheet:<\/span> <\/p>\n
\"\"<\/p>\n
 Jika saya membuka file CSV player_stats<\/strong> menggunakan Notepad, saya dapat melihat bahwa nilai dalam file Excel disimpan sebagai nilai yang dipisahkan koma:<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa dalam contoh ini kami dapat menyimpan dua lembar ke buku kerja kami sebagai file CSV individual, namun makro yang sama ini akan berfungsi dengan jumlah lembar berapa pun.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n
 VBA: Cara menghitung jumlah lembar dalam buku kerja<\/a>
 VBA: Cara mengekstrak data dari buku kerja lain
 VBA: Bagaimana cara menambahkan sheet baru<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda bisa menggunakan sintaks berikut di VBA untuk menyimpan setiap lembar buku kerja ke file CSV: Sub SaveCSV() Dim Ws As Worksheet Dim SaveDir As String Dim CurrentWorkbook As String Dim CurrentFormat As Long CurrentWorkbook = ThisWorkbook.FullName CurrentFormat = ThisWorkbook.FileFormat ‘specify directory to save CSV files in SaveDir = ” C:\\Users\\bobbi\\OneDrive\\Desktop\\ ” ‘save each sheet […]<\/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":"\nVBA: Cara menyimpan sheet sebagai file CSV (dengan contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menyimpan lembar Excel sebagai file CSV, 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-simpan-sebagai-csv\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara menyimpan sheet sebagai file CSV (dengan contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menyimpan lembar Excel sebagai file CSV, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-simpan-sebagai-csv\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-10T20:54:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/economiseur1.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-simpan-sebagai-csv\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-simpan-sebagai-csv\/\",\"name\":\"VBA: Cara menyimpan sheet sebagai file CSV (dengan contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-10T20:54:36+00:00\",\"dateModified\":\"2023-07-10T20:54:36+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menyimpan lembar Excel sebagai file CSV, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-simpan-sebagai-csv\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-simpan-sebagai-csv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-simpan-sebagai-csv\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menyimpan spreadsheet sebagai file csv (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":"VBA: Cara menyimpan sheet sebagai file CSV (dengan contoh) - Statorials","description":"Tutorial ini menjelaskan cara menyimpan lembar Excel sebagai file CSV, 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-simpan-sebagai-csv\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menyimpan sheet sebagai file CSV (dengan contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara menyimpan lembar Excel sebagai file CSV, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/vba-simpan-sebagai-csv\/","og_site_name":"Statorials","article_published_time":"2023-07-10T20:54:36+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/economiseur1.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-simpan-sebagai-csv\/","url":"https:\/\/statorials.org\/id\/vba-simpan-sebagai-csv\/","name":"VBA: Cara menyimpan sheet sebagai file CSV (dengan contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-10T20:54:36+00:00","dateModified":"2023-07-10T20:54:36+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menyimpan lembar Excel sebagai file CSV, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-simpan-sebagai-csv\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-simpan-sebagai-csv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-simpan-sebagai-csv\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menyimpan spreadsheet sebagai file csv (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\/4469"}],"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=4469"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4469\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4469"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4469"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4469"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}