{"id":1548,"date":"2023-11-17T10:05:20","date_gmt":"2023-11-17T10:05:20","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/periksa-buku-kerja-yang-terbuka\/"},"modified":"2023-12-06T06:14:17","modified_gmt":"2023-12-06T06:14:17","slug":"periksa-buku-kerja-yang-terbuka","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/periksa-buku-kerja-yang-terbuka\/","title":{"rendered":"Bagaimana cara memeriksa apakah buku kerja dibuka melalui vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-859416872\"><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 memeriksa apakah buku kerja terbuka menggunakan kode VBA apa pun, Anda perlu menggunakan perulangan <a href=\"https:\/\/exceladvisor.org\/id\/untuk-lingkaran\/\">FOR EACH<\/a> yang dapat mengulang semua buku kerja yang terbuka saat ini dan memeriksa nama setiap buku kerja dengan nama yang Anda sebutkan. Anda dapat menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/kotak-pesan-vba\/\">kotak pesan<\/a> untuk mendapatkan hasil perulangan. Atau bisa juga melakukan kode untuk memasukkan hasilnya ke dalam sel.<\/p><h2 class=\"wp-block-heading\"> Periksa JIKA BUKU KERJA TERBUKA<\/h2><ol><li> Pertama, Anda perlu <a href=\"https:\/\/exceladvisor.org\/id\/variabel\/\">mendeklarasikan variabel<\/a> yang akan digunakan dalam kode untuk membuat loop. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-buat-satu-lingkaran\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-boucle.png\" sizes=\"auto, \" srcset=\"\" alt=\"create a loop\" width=\"365\" height=\"180\"><\/li><li> Gunakan kotak input untuk mendapatkan nama buku kerja yang ingin Anda cari. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-menggunakan-kotak-masuk\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-utiliser-une-zone-de-saisie.png\" sizes=\"auto, \" srcset=\"\" alt=\"use an input box\" width=\"448\" height=\"172\"><\/li><li> Mulai perulangan untuk menelusuri semua buku kerja yang terbuka. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-mulai-loop-ke-loop\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-demarrer-la-boucle-a-boucle.png\" sizes=\"auto, \" srcset=\"\" alt=\"start the loop to loop\" width=\"451\" height=\"204\"><\/li><li> Tulis kode dengan <a href=\"https:\/\/exceladvisor.org\/id\/jika-2\/\">IF STATEMENT<\/a> untuk memeriksa nama buku kerja dengan nama yang Anda masukkan di kotak input, dan setelah namanya cocok, aktifkan buku kerja, tampilkan kotak pesan yang mengatakan buku kerja ditemukan, dan keluar dari prosedur. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-kode-dengan-jika-pernyataan\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-code-avec-instruction-if.png\" sizes=\"auto, \" srcset=\"\" alt=\"code with if statement\" width=\"436\" height=\"332\"><\/li><li> Pada akhirnya, selesaikan perulangan dan gunakan kotak pesan untuk menampilkan kotak pesan jika tidak ada yang ditemukan. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-akhiri-loop-dan-gunakan-kotak pesan\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-terminer-la-boucle-et-utiliser-une-boite-de-message.png\" sizes=\"auto, \" srcset=\"\" alt=\"end the loop and use a message box\" width=\"477\" height=\"332\"><\/li><\/ol><p class=\"content-box-grey\"><mark class=\"has-inline-color\" style=\"background-color: #ffdc1a;\"> <strong>Tautan yang berguna:<\/strong> <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><\/mark><\/p><p> Berikut kode lengkapnya.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_check_workbook() Dim WB As Workbook Dim myWB As String myWB = InputBox(Prompt:=\"Enter the workbook name.\") For Each WB In Workbooks If WB.Name = myWB Then WB.Activate MsgBox \"Workbook Found!\" Exit Sub End If Next WB MsgBox \"Not Found\" 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\/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><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/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-1548","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 memeriksa apakah buku kerja dibuka melalui VBA di Excel?<\/title>\n<meta name=\"description\" content=\"Tutorial ini membantu Anda mempelajari cara menggunakan VBA untuk memeriksa apakah file Excel tertentu terbuka dan setelah pemeriksaan mengaktifkannya\" \/>\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\/periksa-buku-kerja-yang-terbuka\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara memeriksa apakah buku kerja dibuka melalui VBA di Excel?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini membantu Anda mempelajari cara menggunakan VBA untuk memeriksa apakah file Excel tertentu terbuka dan setelah pemeriksaan mengaktifkannya\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/periksa-buku-kerja-yang-terbuka\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:14:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-boucle.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/periksa-buku-kerja-yang-terbuka\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/periksa-buku-kerja-yang-terbuka\/\",\"name\":\"Bagaimana cara memeriksa apakah buku kerja dibuka melalui VBA di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/periksa-buku-kerja-yang-terbuka\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/periksa-buku-kerja-yang-terbuka\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-boucle.png\",\"datePublished\":\"2023-11-17T10:05:20+00:00\",\"dateModified\":\"2023-12-06T06:14:17+00:00\",\"description\":\"Tutorial ini membantu Anda mempelajari cara menggunakan VBA untuk memeriksa apakah file Excel tertentu terbuka dan setelah pemeriksaan mengaktifkannya\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/periksa-buku-kerja-yang-terbuka\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/periksa-buku-kerja-yang-terbuka\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/periksa-buku-kerja-yang-terbuka\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-boucle.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-boucle.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/periksa-buku-kerja-yang-terbuka\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara memeriksa apakah buku kerja dibuka melalui 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 memeriksa apakah buku kerja dibuka melalui VBA di Excel?","description":"Tutorial ini membantu Anda mempelajari cara menggunakan VBA untuk memeriksa apakah file Excel tertentu terbuka dan setelah pemeriksaan mengaktifkannya","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\/periksa-buku-kerja-yang-terbuka\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara memeriksa apakah buku kerja dibuka melalui VBA di Excel?","og_description":"Tutorial ini membantu Anda mempelajari cara menggunakan VBA untuk memeriksa apakah file Excel tertentu terbuka dan setelah pemeriksaan mengaktifkannya","og_url":"https:\/\/exceladvisor.org\/id\/periksa-buku-kerja-yang-terbuka\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:14:17+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-boucle.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/periksa-buku-kerja-yang-terbuka\/","url":"https:\/\/exceladvisor.org\/id\/periksa-buku-kerja-yang-terbuka\/","name":"Bagaimana cara memeriksa apakah buku kerja dibuka melalui VBA di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/periksa-buku-kerja-yang-terbuka\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/periksa-buku-kerja-yang-terbuka\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-boucle.png","datePublished":"2023-11-17T10:05:20+00:00","dateModified":"2023-12-06T06:14:17+00:00","description":"Tutorial ini membantu Anda mempelajari cara menggunakan VBA untuk memeriksa apakah file Excel tertentu terbuka dan setelah pemeriksaan mengaktifkannya","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/periksa-buku-kerja-yang-terbuka\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/periksa-buku-kerja-yang-terbuka\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/periksa-buku-kerja-yang-terbuka\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-boucle.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-boucle.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/periksa-buku-kerja-yang-terbuka\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara memeriksa apakah buku kerja dibuka melalui 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\/1548","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=1548"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1548\/revisions"}],"predecessor-version":[{"id":2342,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1548\/revisions\/2342"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1548"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}