{"id":1577,"date":"2023-11-16T12:02:47","date_gmt":"2023-11-16T12:02:47","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/buku-catatan-ini\/"},"modified":"2023-12-06T06:19:05","modified_gmt":"2023-12-06T06:19:05","slug":"buku-catatan-ini","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/buku-catatan-ini\/","title":{"rendered":"Bagaimana cara menggunakan variabel vba thisworkbook di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-607552668\"><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>Di VBA, Anda bisa menggunakan properti ThisWorkbook untuk merujuk ke buku kerja tempat Anda menulis kode. Saat Anda menggunakannya, Anda memiliki akses ke semua properti dan metode buku kerja saat ini. Sederhananya, Anda bisa <strong>menjalankan semua tugas di buku kerja saat ini<\/strong> tanpa menggunakan nama.<\/p><p> Misalkan Anda ingin menghitung lembar di buku kerja saat ini. Kode yang perlu Anda tulis adalah sebagai berikut. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_thisworkbook() MsgBox ThisWorkbook.Sheets.Count End Sub<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52718\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-ce-classeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-buku kerja ini\" width=\"724\" height=\"283\"><\/figure><\/div><p> Saat Anda menjalankan kode ini, kotak pesan muncul dengan jumlah lembar yang Anda miliki di buku kerja saat ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52719\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-boites-de-message-avec-le-nombre-de-feuilles.png\" sizes=\"auto, \" srcset=\"\" alt=\"kotak pesan-dengan-jumlah-lembar\" width=\"316\" height=\"281\"><\/figure><\/div><p> Seperti yang saya katakan, saat Anda menggunakan ThisWorkbook, ini memberi Anda akses ke properti dan metode buku kerja saat ini. Anda dapat melihat semua ini ketika Anda memasukkan titik (.) untuk melihat daftar lengkap. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52720\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-acces-aux-proprietes.png\" sizes=\"auto, \" srcset=\"\" alt=\"akses-ke-properti\" width=\"362\" height=\"220\"><\/figure><\/div><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\"> Menggunakan ThisWorkbook dengan variabel<\/h2><p> Selanjutnya, saya akan menunjukkan contoh kode nyata untuk mendeklarasikan variabel untuk menggunakan properti ThisWorkbook. Misalkan Anda ingin melakukan beberapa aktivitas di buku kerja saat ini.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_thisworkbook() Dim myWB As Workbook Set myWB = ThisWorkbook With myWB .Activate .Sheets(1).Activate .Range(\"A1\") = Now .Save .Close End With End Sub<\/code><\/pre><p> Di bagian pertama kode ini, Anda memiliki variabel, lalu berikan properti &#8220;Buku Kerja Ini&#8221;. Dan kemudian di bagian kedua Anda memiliki PERNYATAAN WITH untuk melakukan beberapa aktivitas dengan variabel saat ini.<\/p><h2 class=\"wp-block-heading\"> ActiveWorkBook Vs Buku Kerja Ini<\/h2><p> Izinkan saya menjelaskannya kepada Anda dengan analogi sederhana, jadi bersabarlah selama 2 menit berikutnya.<\/p><p> Anda memiliki dua buku kerja yang terbuka secara bersamaan (Buku1 dan Buku2). Anda <strong>menulis kode di book1<\/strong> tetapi book2 aktif saat ini. Jadi ketika Anda menjalankan kode yang mereferensikan ActiveWorkbook ini, ia <strong>akan melakukan aktivitas ini di Book2<\/strong> .<\/p><p> Namun saat Anda menggunakan ThisWorkbook, VBA selalu mengacu pada buku kerja di mana kode tersebut ditulis.<\/p><p> <strong>Begini masalahnya:<\/strong> Selalu lebih baik menggunakan ThisWorkbook karena ini menghilangkan kemungkinan kesalahan.<\/p><h2 class=\"wp-block-heading\" style=\"font-size: 22px;\"> Pelajari selengkapnya tentang buku kerja VBA<\/h2><ul><li class=\"has-normal-font-size\"> <a href=\"https:\/\/exceladvisor.org\/id\/simpan-buku-kerja\/\">VBA Simpan Buku Kerja<\/a><\/li><li class=\"has-normal-font-size\"> <a href=\"https:\/\/exceladvisor.org\/id\/tutup-buku-kerja\/\">VBA Tutup buku kerja<\/a><\/li><li class=\"has-normal-font-size\"> <a href=\"https:\/\/exceladvisor.org\/id\/menghapus-berkas\/\">VBA Hapus buku kerja<\/a><\/li><li class=\"has-normal-font-size\"> <a href=\"https:\/\/exceladvisor.org\/id\/ganti-nama-buku-kerja\/\">VBA mengganti nama buku kerja<\/a><\/li><li class=\"has-normal-font-size\"> <a href=\"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/\">Buku Kerja Aktifkan VBA<\/a><\/li><\/ul>","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-1577","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 menggunakan variabel VBA ThisWorkbook di Excel?<\/title>\n<meta name=\"description\" content=\"Tutorial ini membahas properti thisworkbook di VBA yang bisa Anda gunakan untuk merujuk ke buku kerja yang sedang Anda tulis\" \/>\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\/buku-catatan-ini\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menggunakan variabel VBA ThisWorkbook di Excel?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini membahas properti thisworkbook di VBA yang bisa Anda gunakan untuk merujuk ke buku kerja yang sedang Anda tulis\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/buku-catatan-ini\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-ce-classeur.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\/buku-catatan-ini\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/buku-catatan-ini\/\",\"name\":\"Bagaimana cara menggunakan variabel VBA ThisWorkbook di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/buku-catatan-ini\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/buku-catatan-ini\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-ce-classeur.png\",\"datePublished\":\"2023-11-16T12:02:47+00:00\",\"dateModified\":\"2023-12-06T06:19:05+00:00\",\"description\":\"Tutorial ini membahas properti thisworkbook di VBA yang bisa Anda gunakan untuk merujuk ke buku kerja yang sedang Anda tulis\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/buku-catatan-ini\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/buku-catatan-ini\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/buku-catatan-ini\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-ce-classeur.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-ce-classeur.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/buku-catatan-ini\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan variabel vba thisworkbook di excel?\"}]},{\"@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 menggunakan variabel VBA ThisWorkbook di Excel?","description":"Tutorial ini membahas properti thisworkbook di VBA yang bisa Anda gunakan untuk merujuk ke buku kerja yang sedang Anda tulis","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\/buku-catatan-ini\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menggunakan variabel VBA ThisWorkbook di Excel?","og_description":"Tutorial ini membahas properti thisworkbook di VBA yang bisa Anda gunakan untuk merujuk ke buku kerja yang sedang Anda tulis","og_url":"https:\/\/exceladvisor.org\/id\/buku-catatan-ini\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:05+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-ce-classeur.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\/buku-catatan-ini\/","url":"https:\/\/exceladvisor.org\/id\/buku-catatan-ini\/","name":"Bagaimana cara menggunakan variabel VBA ThisWorkbook di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/buku-catatan-ini\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/buku-catatan-ini\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-ce-classeur.png","datePublished":"2023-11-16T12:02:47+00:00","dateModified":"2023-12-06T06:19:05+00:00","description":"Tutorial ini membahas properti thisworkbook di VBA yang bisa Anda gunakan untuk merujuk ke buku kerja yang sedang Anda tulis","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/buku-catatan-ini\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/buku-catatan-ini\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/buku-catatan-ini\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-ce-classeur.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-ce-classeur.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/buku-catatan-ini\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan variabel vba thisworkbook di excel?"}]},{"@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\/1577","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=1577"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1577\/revisions"}],"predecessor-version":[{"id":2807,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1577\/revisions\/2807"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}