{"id":1544,"date":"2023-11-17T11:16:22","date_gmt":"2023-11-17T11:16:22","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/tutup-buku-kerja\/"},"modified":"2023-12-06T06:18:49","modified_gmt":"2023-12-06T06:18:49","slug":"tutup-buku-kerja","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/tutup-buku-kerja\/","title":{"rendered":"Bagaimana cara menutup buku kerja excel menggunakan vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-874926239\"><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 menutup file Excel, Anda harus menggunakan metode \u201cTutup\u201d. Dengan metode ini, Anda dapat menentukan apakah Anda ingin menyimpan perubahan atau tidak. Dan, jika Anda ingin menyimpan dan menutup file yang belum disimpan, Anda dapat menentukan jalur penyimpanannya sebelum menutupnya.<\/p><p> Berikut adalah sintaks dari metode close. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Workbook.Close (SaveChanges, FileName, RouteWorkbook)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53194\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fermer-un-classeur-en-utilisant-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"tutup buku kerja dengan vba\" width=\"599\" height=\"179\"><\/figure><\/div><h2 class=\"wp-block-heading\"> <strong>Langkah-langkah untuk menutup buku kerja<\/strong><\/h2><ol type=\"1\"><li> Tentukan buku kerja yang ingin Anda tutup.<\/li><li> Gunakan metode tutup dengan buku kerja ini.<\/li><li> Dalam metode kode, tunjukkan apakah Anda ingin menyimpan file atau tidak.<\/li><li> Di bagian akhir sebutkan jalur tempat Anda ingin menyimpan file sebelum ditutup.<\/li><\/ol><p> Dalam tutorial ini, kita akan melihat berbagai cara untuk menutup buku kerja di Excel menggunakan VBA.<\/p><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><h2 class=\"wp-block-heading\"> <strong>Tutup buku kerja tanpa menyimpan<\/strong><\/h2><p> Jika Anda ingin menyimpan buku kerja yang aktif tanpa menyimpannya, Anda perlu menggunakan kode seperti ini.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">ActiveWorkbook.Close SaveChanges:=False<\/code><\/pre><p> Dalam kode ini, saya menentukan \u201cFalse\u201d untuk argumen \u201cSaveChanges\u201d. Jadi VBA akan mengabaikan jika ada perubahan pada workbook yang tidak disimpan. Dan jika Anda ingin menutup buku kerja tertentu, Anda bisa menggunakan nama buku kerja tersebut. Sama seperti kode berikut.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Workbooks(\"book1\").Close SaveChanges:=False<\/code><\/pre><p> Jika Anda memiliki data di buku kerja dan Anda mengabaikan argumen &#8220;Simpan Perubahan&#8221;, Excel akan menampilkan kotak dialog untuk mengonfirmasi apakah Anda ingin menyimpan buku kerja atau tidak. Intinya begini: lebih baik menentukan argumen &#8220;SaveChanges&#8221; meskipun itu opsional.<\/p><h2 class=\"wp-block-heading\"> <strong>Tutup buku kerja setelah menyimpannya<\/strong><\/h2><p> Seperti yang Anda lihat, ada argumen dalam metode CLOSE untuk menentukan lokasi jalur. Katakanlah Anda ingin menyimpan &#8220;Book6&#8221; ke folder di desktop. Ini kode yang perlu Anda gunakan.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Workbooks(\"Book6\").Close _ SaveChanges:=True, _ Filename:=\"C:UsersDellDesktopmyFoldermyFile.xlsx\"<\/code><\/pre><p> Kode ini akan menyimpan buku kerja \u201cBook6\u201d di folder yang disimpan di desktop saya dengan nama \u201cmyFILE.xlsx\u201d. <strong>Namun ada satu hal yang perlu Anda perhatikan:<\/strong> jika Anda sudah memiliki buku kerja dengan nama yang sama, file tersebut akan diganti dengan yang baru.<\/p><p> Tenang saja, ada solusi yang bisa Anda gunakan. Kode berikut memeriksa apakah ada file dengan nama yang ingin Anda gunakan<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_close_workbook() Dim wbCheck As String wbCheck = Dir(\"C:UsersDellDesktopmyFoldermyFile.xlsx\") If wbCheck = \"\" Then Workbooks(\"Book6\").Close _ SaveChanges:=True, _ Filename:=\"C:UsersDellDesktopmyFoldermyFile.xlsx\" Else MsgBox \"Error! Name already used.\" End If End Sub<\/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\/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\/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-1544","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 menutup buku kerja Excel menggunakan VBA?<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menutup buku kerja menggunakan kode VBA (tanpa menyimpan file atau menyimpannya sebelum menutupnya).\" \/>\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\/tutup-buku-kerja\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menutup buku kerja Excel menggunakan VBA?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menutup buku kerja menggunakan kode VBA (tanpa menyimpan file atau menyimpannya sebelum menutupnya).\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/tutup-buku-kerja\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fermer-un-classeur-en-utilisant-vba.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\/tutup-buku-kerja\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/tutup-buku-kerja\/\",\"name\":\"Bagaimana cara menutup buku kerja Excel menggunakan VBA?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tutup-buku-kerja\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tutup-buku-kerja\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fermer-un-classeur-en-utilisant-vba.png\",\"datePublished\":\"2023-11-17T11:16:22+00:00\",\"dateModified\":\"2023-12-06T06:18:49+00:00\",\"description\":\"Tutorial ini menjelaskan cara menutup buku kerja menggunakan kode VBA (tanpa menyimpan file atau menyimpannya sebelum menutupnya).\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tutup-buku-kerja\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/tutup-buku-kerja\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tutup-buku-kerja\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fermer-un-classeur-en-utilisant-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fermer-un-classeur-en-utilisant-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tutup-buku-kerja\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menutup 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":"Bagaimana cara menutup buku kerja Excel menggunakan VBA?","description":"Tutorial ini menjelaskan cara menutup buku kerja menggunakan kode VBA (tanpa menyimpan file atau menyimpannya sebelum menutupnya).","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\/tutup-buku-kerja\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menutup buku kerja Excel menggunakan VBA?","og_description":"Tutorial ini menjelaskan cara menutup buku kerja menggunakan kode VBA (tanpa menyimpan file atau menyimpannya sebelum menutupnya).","og_url":"https:\/\/exceladvisor.org\/id\/tutup-buku-kerja\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:49+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fermer-un-classeur-en-utilisant-vba.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\/tutup-buku-kerja\/","url":"https:\/\/exceladvisor.org\/id\/tutup-buku-kerja\/","name":"Bagaimana cara menutup buku kerja Excel menggunakan VBA?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/tutup-buku-kerja\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/tutup-buku-kerja\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fermer-un-classeur-en-utilisant-vba.png","datePublished":"2023-11-17T11:16:22+00:00","dateModified":"2023-12-06T06:18:49+00:00","description":"Tutorial ini menjelaskan cara menutup buku kerja menggunakan kode VBA (tanpa menyimpan file atau menyimpannya sebelum menutupnya).","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/tutup-buku-kerja\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/tutup-buku-kerja\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/tutup-buku-kerja\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fermer-un-classeur-en-utilisant-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fermer-un-classeur-en-utilisant-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/tutup-buku-kerja\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menutup 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\/1544","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=1544"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1544\/revisions"}],"predecessor-version":[{"id":2772,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1544\/revisions\/2772"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1544"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}